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.

pthorsel

Newbie Poster

1 post since Dec 2004

Reputation Points: 10

Solved Threads: 0

6 Years Ago

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.

NetDev

Newbie Poster

2 posts since Dec 2005

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months

You