Can not find installable ISAM

Installed Office 2007 and I am trying to develop an import by developing a Integration Project. If I use SQL2005 to import the data to create the table or I try to develop the Integration Project I keep getting a Can not find installable ISAM. I have tried to update the MDAC but either the SP is not supported in XP SP2 or it would do anything since there is a later version already installed. This is the same when I try and install / update the Jet database engine.(4.0). Does anyone have a clue, the only thing I can find info on is Access and other db's. This appears to be a product issue but which one I don't know.i have been battling this same issue only i'm trying to import an excel spreadsheet in ssis. if you find anything, please do post here. i'll do the same.|||Have you tried using the ACE provider instead of Jet? For more info, look up the Office 2007 Connectivity article in the Connectivity post in the beginning of this forum.|||If you are trying to import from Excel, there is a source adapter called Data Defractor. It's far more adaptive that using Jet. If you Excel is basically a CSV, then Jet will suffice but anything more complex....

It does a great job of importing from Excel. See www.dataDefractor.com for more info.

Can not connect to SQL Server from DMZ

We just moved to a new office. After setting up the servers, we found
that the apllication (including SQL Query Analyzer) in DMZ can not
access SQL server that is behind the firewall. We can ping the SQL
server from the server in DMZ and we also checked and confirmed port
1433 is open from the firewall. Could anyone help me out?
Thanks,Run the following test:
ISQL -Stcp:sqlnamehere -Uuserid -Ppassword -Q"select @.@.version"
Post the Error message.
Winsock Error messages should be returned if it fails.
Example:
11001 == Host Not Found
10060 == Connection Timeout
10061 == Connection Refused
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can I use MSDE in a Microsoft's Corporate Client

I Work in a Corporation where SQL is not an standard to deploy but office 2000 are desktop utilities by default. They use access, word, excell, etc to work. Can I use MSDE with Vb 6 and how can I administer the MSDE database ? I have seen Access frontend
to make changes and permisions and its very poor. Can I use Sql Server Console or Third parts ?
Thanks
hi,
"Designer improving costs" <janou_dank@.yahoo.com.ar> ha scritto nel
messaggio news:F799D60E-DC43-480E-BE57-6EC9E7C02B47@.microsoft.com...
> I Work in a Corporation where SQL is not an standard to deploy but office
2000 are desktop utilities
>by default. They use access, word, excell, etc to work. Can I use MSDE with
Vb 6 and how can I
>administer the MSDE database ? I have seen Access frontend to make changes
and permisions and
>its very poor. Can I use Sql Server Console or Third parts ?
> Thanks
you can download and install MSDE for sure in corporate environments, as
MSDE release A (http://www.microsoft.com/sql/msde/do...s/download.asp) is
free..
as regard management, you can use SQL Server management tools like
Enterprise Manager and Query Analyzer only if you a licensed owner of a full
SQL Server edition, but you can write your own tool, use Acces and/or resort
to third parties tools like those provided at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||If you have licensed SQL Server ownership with which the tools are
available, you can use the tools to manage the MSDE installations.

Can I store a file in a SQL Server Database?

I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
Also the database where this table is created should provide similar functionality as a file server open, edit, check in, and check out on stored files. Can I do this in SQL Server 2000?As fare as I know, SQL Server has no specific support for office files.

So, you have the choice between re-inventing the functionality of document information systems, or to buy some. These systems are storing office files as BLOBs to keep all controls, and they are storing the text in a separate TEXT field to enable searching.

However, there is a third way: store only the path to the documents on your netwerk, and use Office's functionality to prevent users to open the same document twice.

Can I store a file in a SQL Server Database?

I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
Also the database where this table is created should provide similar functionality as a file server open, edit, check in, and check out on stored files. Can I do this in SQL Server 2000?You can store documents in the text or image data type.

You probably can't search on them, but your could store a summary in a character-based field with the record, or a column that just contains keywords.

Yes, you can provide functionality similar to a file-server...you just have to write it all yourself. :(

I can tell you that you are looking at a daunting project here that will likely involve complex coding. The user-interface will probably also prove difficult.

Perhaps somebody else on the forum will see this post and could recommend some professionally designed 3rd party software for document management?

blindman

Can I Mirror my Databases With a Third Party Affordably?

I need to work out a solution for my scenario.
The Problem: two GUI applications that use SQL databases as back
ends. We have a central office and three branch locations. The
central office will have three users pulling from a combination of the
applications at any given time. One branch office might have two
people using the applications, and the other offices might have one,
rarely, using the applications. The databases themselves are 600MB
and 400MB respectively. The central office has as SDSL connection of
1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
The central office has active VPN tunnels with each of the branch
offices. A server at the central office handles Exchange for the
organization, and is the primary replicator for file sharing, DNS, and
Domain Controlling (for partner servers at two of the branch
locations). I've built a new SQL server machine with SQL Server 2005
Enterprise for the central office that's more than fast and tough
enough for the needs I've described. My concern is that the DSL
connection at the central office will not be fast enough to serve the
branch offices, (especially with the VPN overhead).
My Question and Proposed Solution: I figure that the SQL server
machine that I set up can easily handle the central office. Can I
have an internet company with a fast connection mirror my databases on
their servers, (host copies of them) for the branch officesr? How
much should I pay for this per month?
As always, I greatly appreciate any help.
Thank you.Hi
"ffrugone@.gmail.com" wrote:
> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>
You don't say how the application talks to the database or if the remote
locations will be doing any updates or not? Have you tested the remote
access to make sure it can communitate with the database and the application
response is ok or not?
If the remote locations are read only, you could use log shipping for a
local copy at the remote sites. If they do update the database, you may be
able to do merge replication, although a better option may be to have a web
application centrally that everyone uses.
John|||Terminal Services/Citrix may be an option.
<ffrugone@.gmail.com> wrote in message
news:1177913253.393889.200670@.u30g2000hsc.googlegroups.com...
> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>

Can I Mirror my Databases With a Third Party Affordably?

I need to work out a solution for my scenario.
The Problem: two GUI applications that use SQL databases as back
ends. We have a central office and three branch locations. The
central office will have three users pulling from a combination of the
applications at any given time. One branch office might have two
people using the applications, and the other offices might have one,
rarely, using the applications. The databases themselves are 600MB
and 400MB respectively. The central office has as SDSL connection of
1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
The central office has active VPN tunnels with each of the branch
offices. A server at the central office handles Exchange for the
organization, and is the primary replicator for file sharing, DNS, and
Domain Controlling (for partner servers at two of the branch
locations). I've built a new SQL server machine with SQL Server 2005
Enterprise for the central office that's more than fast and tough
enough for the needs I've described. My concern is that the DSL
connection at the central office will not be fast enough to serve the
branch offices, (especially with the VPN overhead).
My Question and Proposed Solution: I figure that the SQL server
machine that I set up can easily handle the central office. Can I
have an internet company with a fast connection mirror my databases on
their servers, (host copies of them) for the branch officesr? How
much should I pay for this per month?
As always, I greatly appreciate any help.
Thank you.Hi
"ffrugone@.gmail.com" wrote:

> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>
You don't say how the application talks to the database or if the remote
locations will be doing any updates or not? Have you tested the remote
access to make sure it can communitate with the database and the application
response is ok or not?
If the remote locations are read only, you could use log shipping for a
local copy at the remote sites. If they do update the database, you may be
able to do merge replication, although a better option may be to have a web
application centrally that everyone uses.
John|||Terminal Services/Citrix may be an option.
<ffrugone@.gmail.com> wrote in message
news:1177913253.393889.200670@.u30g2000hsc.googlegroups.com...
> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>

Can I Mirror my Databases With a Third Party Affordably?

I need to work out a solution for my scenario.
The Problem: two GUI applications that use SQL databases as back
ends. We have a central office and three branch locations. The
central office will have three users pulling from a combination of the
applications at any given time. One branch office might have two
people using the applications, and the other offices might have one,
rarely, using the applications. The databases themselves are 600MB
and 400MB respectively. The central office has as SDSL connection of
1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
The central office has active VPN tunnels with each of the branch
offices. A server at the central office handles Exchange for the
organization, and is the primary replicator for file sharing, DNS, and
Domain Controlling (for partner servers at two of the branch
locations). I've built a new SQL server machine with SQL Server 2005
Enterprise for the central office that's more than fast and tough
enough for the needs I've described. My concern is that the DSL
connection at the central office will not be fast enough to serve the
branch offices, (especially with the VPN overhead).
My Question and Proposed Solution: I figure that the SQL server
machine that I set up can easily handle the central office. Can I
have an internet company with a fast connection mirror my databases on
their servers, (host copies of them) for the branch officesr? How
much should I pay for this per month?
As always, I greatly appreciate any help.
Thank you.
Hi
"ffrugone@.gmail.com" wrote:

> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>
You don't say how the application talks to the database or if the remote
locations will be doing any updates or not? Have you tested the remote
access to make sure it can communitate with the database and the application
response is ok or not?
If the remote locations are read only, you could use log shipping for a
local copy at the remote sites. If they do update the database, you may be
able to do merge replication, although a better option may be to have a web
application centrally that everyone uses.
John
|||Terminal Services/Citrix may be an option.
<ffrugone@.gmail.com> wrote in message
news:1177913253.393889.200670@.u30g2000hsc.googlegr oups.com...
> I need to work out a solution for my scenario.
> The Problem: two GUI applications that use SQL databases as back
> ends. We have a central office and three branch locations. The
> central office will have three users pulling from a combination of the
> applications at any given time. One branch office might have two
> people using the applications, and the other offices might have one,
> rarely, using the applications. The databases themselves are 600MB
> and 400MB respectively. The central office has as SDSL connection of
> 1.1Mbps and the branch offices each have ADSL connections of 1.5/386.
> The central office has active VPN tunnels with each of the branch
> offices. A server at the central office handles Exchange for the
> organization, and is the primary replicator for file sharing, DNS, and
> Domain Controlling (for partner servers at two of the branch
> locations). I've built a new SQL server machine with SQL Server 2005
> Enterprise for the central office that's more than fast and tough
> enough for the needs I've described. My concern is that the DSL
> connection at the central office will not be fast enough to serve the
> branch offices, (especially with the VPN overhead).
> My Question and Proposed Solution: I figure that the SQL server
> machine that I set up can easily handle the central office. Can I
> have an internet company with a fast connection mirror my databases on
> their servers, (host copies of them) for the branch officesr? How
> much should I pay for this per month?
> As always, I greatly appreciate any help.
> Thank you.
>