akulap
asked on
How to ceate ADO 'DSN-Less connection' for Visual Foxpro
Can I create ADO 'DSN-Less connection' for Visual Foxpro 6.0 free tables.
Eg.: object.DataSource = <DSN Name>
I want to use "C:\MyDirectory\"
Is it possible, If yes How
Eg.: object.DataSource = <DSN Name>
I want to use "C:\MyDirectory\"
Is it possible, If yes How
krees changed the proposed answer to a comment
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To create an ADO DSN-less connection you must specify in your ADODB.Connection object the string supplied as your datasource for the object.
For example:
dim adoconn as adodb.connection
adoConn.ConnectionString = "driver={Visual FoxPro Database}; datasource=C:\MyDir;"
Hope this works for you...