Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.Using linked server is one of the ways, and I will probably go with that.
But am not sure where to get your BDE drivers...try Googling :-)
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com> wrote
in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
Hello,
I was wondering what is the best way to link MS SQL server 2000 to dBase IV.
From what I can gather, we should create a linked server and use the MS Jet
4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
dBase files.
Is this the correct way? If so, does anyone know where to get a working
version of BDE?
Thanks,
Marc.|||I have googled for it but haven't found a way to get a copy yet.
I am open to any methods really. I really would prefer not to use BDE.
Thanks,
Marc.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:OzhenZt#DHA.2072@.TK2MSFTNGP11.phx.gbl...
> Using linked server is one of the ways, and I will probably go with that.
> But am not sure where to get your BDE drivers...try Googling :-)
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Marc Thompson" <(NO SPAM) my email address is marc at sycron dot com>
wrote
> in message news:uuRlYTt%23DHA.3284@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I was wondering what is the best way to link MS SQL server 2000 to dBase
IV.
> From what I can gather, we should create a linked server and use the MS
Jet
> 4.0 OLE DB provider to connect to Borland's BDE. Then BDE links to the
> dBase files.
> Is this the correct way? If so, does anyone know where to get a working
> version of BDE?
> Thanks,
> Marc.
>
>
Showing posts with label dbase. Show all posts
Showing posts with label dbase. Show all posts
Saturday, February 25, 2012
Friday, February 17, 2012
Create DBF file from ADO.Net
Hi Guys,
I have a requirement from a client to take some data from their SQL Server and create a Dbase 5 file with it. Scoured the forums looking for the answer but no luck. Any ideas?
Iain
SQL Server has Data Transformation Services (DTS) that allows to export data into different formats depending on providers and drives installed on that PC. I believe this is what you need|||Yeah - DTS is the obvious answer for this but I don't actually have access to their server to create packages. That's why I was looking to do it in code with a dataset/reader and maybe some kind of OLEDB driver. Any ideas?|||Hi Iain,
Yes, you'd need an OLE DB data provider for Dbase 5. A web search brings up several third-party vendors whose products can access Dbase files, but I don't know which versions.
|||i think foxpro can read from sql server
and can write to dbf files.
foxpro is not using dataset technology but it has extensive
support for different databases
|||I think you should look at a solution other than ADO.Net, I suspect Jet can do this from Native Code.|||Hi Joey,
Yes, Visual FoxPro can integrate successfully with SQL Server, both FoxPro accessing SQL Server and SQL Server accessing FoxPro data.
Visual FoxPro can read all versions of FoxPro DBFs. However, the DBFs Ian was talking about were Dbase 5 DBFs and may not be compatible with Visual FoxPro's native data handling or ODBC drivers or OLE DB data provider/
|||Thanks for the input guys. Looks like I'll have to try and find some 3rd party components. This is a little more difficult than I expected it to be!
|||Hello IainH,
I am having a similar problem of creating a DBF file from a ADO.net DataSet, Please let me know if you find any solution.
Thanks In Advance,
Swetha
Create DBF file from ADO.Net
Hi Guys,
I have a requirement from a client to take some data from their SQL Server and create a Dbase 5 file with it. Scoured the forums looking for the answer but no luck. Any ideas?
Iain
SQL Server has Data Transformation Services (DTS) that allows to export data into different formats depending on providers and drives installed on that PC. I believe this is what you need|||Yeah - DTS is the obvious answer for this but I don't actually have access to their server to create packages. That's why I was looking to do it in code with a dataset/reader and maybe some kind of OLEDB driver. Any ideas?|||Hi Iain,
Yes, you'd need an OLE DB data provider for Dbase 5. A web search brings up several third-party vendors whose products can access Dbase files, but I don't know which versions.
|||
i think foxpro can read from sql server
and can write to dbf files.
foxpro is not using dataset technology but it has extensive
support for different databases
|||I think you should look at a solution other than ADO.Net, I suspect Jet can do this from Native Code.|||Hi Joey,
Yes, Visual FoxPro can integrate successfully with SQL Server, both FoxPro accessing SQL Server and SQL Server accessing FoxPro data.
Visual FoxPro can read all versions of FoxPro DBFs. However, the DBFs Ian was talking about were Dbase 5 DBFs and may not be compatible with Visual FoxPro's native data handling or ODBC drivers or OLE DB data provider/
|||Thanks for the input guys. Looks like I'll have to try and find some 3rd party components. This is a little more difficult than I expected it to be!
|||Hello IainH,
I am having a similar problem of creating a DBF file from a ADO.net DataSet, Please let me know if you find any solution.
Thanks In Advance,
Swetha
Create DBF file from ADO.Net
Hi Guys,
I have a requirement from a client to take some data from their SQL Server and create a Dbase 5 file with it. Scoured the forums looking for the answer but no luck. Any ideas?
Iain
SQL Server has Data Transformation Services (DTS) that allows to export data into different formats depending on providers and drives installed on that PC. I believe this is what you need|||Yeah - DTS is the obvious answer for this but I don't actually have access to their server to create packages. That's why I was looking to do it in code with a dataset/reader and maybe some kind of OLEDB driver. Any ideas?|||Hi Iain,
Yes, you'd need an OLE DB data provider for Dbase 5. A web search brings up several third-party vendors whose products can access Dbase files, but I don't know which versions.
|||i think foxpro can read from sql server
and can write to dbf files.
foxpro is not using dataset technology but it has extensive
support for different databases
|||I think you should look at a solution other than ADO.Net, I suspect Jet can do this from Native Code.|||Hi Joey,
Yes, Visual FoxPro can integrate successfully with SQL Server, both FoxPro accessing SQL Server and SQL Server accessing FoxPro data.
Visual FoxPro can read all versions of FoxPro DBFs. However, the DBFs Ian was talking about were Dbase 5 DBFs and may not be compatible with Visual FoxPro's native data handling or ODBC drivers or OLE DB data provider/
|||Thanks for the input guys. Looks like I'll have to try and find some 3rd party components. This is a little more difficult than I expected it to be!
|||Hello IainH,
I am having a similar problem of creating a DBF file from a ADO.net DataSet, Please let me know if you find any solution.
Thanks In Advance,
Swetha
Subscribe to:
Posts (Atom)