Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 474
  • Last Modified:

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
0
akulap
Asked:
akulap
  • 3
1 Solution
 
kreesCommented:
Hi there

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...
0
 
kreesCommented:
krees changed the proposed answer to a comment
0
 
kreesCommented:
Sorry there was an error on the DSN

Hi there

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={Microsoft Visual FoxPro Driver}; datasource=C:\MyDir;"

Hope this works for you...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now