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.
| Author |
Topic |
|
tefu
Starting Member
6 Posts |
 Posted - 2008-11-23 : 18:41:49
|
| Hi,Could you please help me? What I was trying to do is to open a connection string to Visual Foxpro database and do the SQL statement to that database and loop the data that I gather from the SQL statement.I am having a hard time to find an example on the net on how to read the database from SQL 2005.Thanks. |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-11-23 : 19:57:17
|
| Try this method, this may help you. 1). create an ODBC connection to VFP Database2). Create a .Net Providers/ODBC Data Provider Connection and select the data source from step13). Use DataReader source to read data from VFP source using step 2 connection.4). in the script component (using Source, Designation, Transformation type) you can do your processhey |
 |
|
|
tefu
Starting Member
6 Posts |
Posted - 2008-11-23 : 20:33:24
|
| Hi Hey,that's exactly what i am trying to do but I am new to SQL 2005. I've done it in VB.NET but my colleges said it's better to do it as store procedure. Now I am trying to convert it to Store procedure... but not sure how to use OLE connection string and use SQL to the VFP database to retrieve the data. |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2008-11-23 : 20:44:53
|
| well, then you can try linkedserver?hey |
|
|
|
|
|
|
Reading from Visual FoxPro 9.0 database