EchoAlertcom
IS-IT--Management
Hello,
I am using the ADODC and I would like to use a connection string that uses the App.Path but I am unsuccessful so far.
I have removed the ConnectionString value from the Properties box. and added to my code:
But gives me the error of:
"Data source name not found and no default driver specified"
I'm not using a DSN -- ALSO >
It works fine when I use:
I appreciate any help.
Thank you.
Steve Funk
I am using the ADODC and I would like to use a connection string that uses the App.Path but I am unsuccessful so far.
I have removed the ConnectionString value from the Properties box. and added to my code:
Code:
datPrimaryRS.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\passwordpal.mdb;Persist Security Info=False"
But gives me the error of:
"Data source name not found and no default driver specified"
I'm not using a DSN -- ALSO >
It works fine when I use:
Code:
datPrimaryRS.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\program files\Password Pal\passwordpal.mdb;Persist Security Info=False"
I appreciate any help.
Thank you.
Steve Funk