Printable View
hi i have created a login form using VB 6 and SQL server 2000 but i on run time i get an error
ERROR -2147467259(80004005)
[Microsoft][ODBC Driver Manager] Data Source name not found
The connection strting used is
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=projects;Initial Catalog=login
Moved to Database forum
Welcome to VBForums! :wave:
The error message means that either your connection string is incomplete, or you do not have the correct driver installed.
Assuming that "projects" is the name of your server, and that "login" is the name of your database, the connection string should be ok.
If you have a version of Windows earlier than XP (such as Windows 2000) it is probably a good idea to install MDAC (which includes drivers for SQL Server), you can find a link to the download in my signature.
hi thaks for the reply.
I downloaded the MDAC and i installed but i still seem to get the same problem...
Ok.. in that case your connection string needs to be checked, eg:
Is the computer that SQL Server is installed on called "projects"?
Is "login" the name of your database?