Connecting to database

Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
Reply

Join Date: Dec 2004
Posts: 1
Reputation: pthorsel is an unknown quantity at this point 
Solved Threads: 0
pthorsel pthorsel is offline Offline
Newbie Poster

Connecting to database

 
0
  #1
Dec 7th, 2004
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.
Reply With Quote Quick reply to this message  
Join Date: Dec 2005
Posts: 2
Reputation: NetDev is an unknown quantity at this point 
Solved Threads: 0
NetDev NetDev is offline Offline
Newbie Poster

Re: Connecting to database

 
0
  #2
Dec 30th, 2005
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC