Link to home
Start Free TrialLog in
Avatar of D_basham
D_basham

asked on

Vb connecting to SQL?

Hello guys and gals. I was wondering if someone could helpe me. I am writing a VB program to connect to SQL database I am using the DSN name. but when I put the DSN name in the program It throws me an error saying OBDC not found or driver not specified. Not when I leave it blank it will prompt to select my data file source name. and it works. What I am I doing wrong? Am I missing something or should I have written this another way? Thank you very much
ASKER CERTIFIED SOLUTION
Avatar of BurtonRacing
BurtonRacing

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of D_basham
D_basham

ASKER

Yeah it is the exact DSN name I thought of that too. I will try the search and if I don't see anything I will post the code. Thank you very much.
you haven't got a valid DRIVER as a provider, check your ADO References.

OR

the database isn't there, or it is there but NOT VALID!!!!!!!

So, yeah!