DaniWeb IT Discussion Community - Connecting to database

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- VB.NET (http://www.daniweb.com/forums/forum58.html)

- - Connecting to database (http://www.daniweb.com/forums/thread15220.html)

pthorsel

Dec 7th, 2004 6:53 pm

Connecting to database

I can connect to my SQL database(remote machine) using VBScript and ASP. I now am trying to connect to the same SQL database using VB.NET in the Microsoft Visual Studio .NET 2003 environment. I get the "SQL Server does not exist or access denied" error. I then took my code and ran it directly on the SQL database server and it allowed me to connect? Any help would be greatly appreciated.

NetDev

Dec 30th, 2005 6:59 am

Re: Connecting to database

Standard Security:

"Data Source=com;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=com;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"

here 'com' is set by ur 32bit ODBC string.

All times are GMT -4. The time now is 10:51 pm.