Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Connections

Author  Topic  vk59 Starting Member 38 Posts Posted - 2005-05-23 : 09:31:06 Hi, I am migrating the data in fox pro 2.6 to SQL Sever using DTS, I am using the below connection objects SQL SERVER (Destination) Dim oConnection As DTS.Connection2 Set oConnection = goPackage.Connections.New("SQLOLEDB") oConnection.Name = "SQL Server" oConnection.ID = 1 oConnection.Reusable = True oConnection.ConnectImmediate = False oConnection.DataSource = MySQLServerName If blnMode Then oConnection.UserID = "sa" oConnection.Password = "sa" oConnection.UseTrustedConnection = False Else oConnection.UseTrustedConnection = True End If oConnection.ConnectionTimeout = 60 oConnection.Catalog = "FoxProMigration" oConnection.UseDSL = False goPackage.Connections.Add oConnection Set oConnection = Nothing FOX PRO(Source) Set oConnection = goPackage.Connections.New("Microsoft.Jet.OLEDB.4.0") oConnection.ConnectionProperties("User ID") = "Admin" oConnection.ConnectionProperties("Data Source") = "c:\FoxproFiles" oConnection.ConnectionProperties("Extended Properties") = "dBase IV" oConnection.Name = "Fox Pro" oConnection.ID = 2 oConnection.Reusable = True oConnection.ConnectImmediate = False oConnection.DataSource = "c:\FoxproFiles" oConnection.UserID = "Admin" oConnection.ConnectionTimeout = 60 oConnection.UseTrustedConnection = False oConnection.UseDSL = False goPackage.Connections.Add oConnection Set oConnection = Nothing This is working fine. But Since my Fox pro tables have memo columns. it is unable to read the source file using the above provider(dBase IV) Do we have any other provider wherein we can connect to FoxPro with a DSN Less Connection. I just have path of dbf files. I Dont want to create user/System DSN Thanks in advance Vinod `