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
0
Newbie Poster
NetDev
0
Newbie Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.