Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO.net and VB.NET connection errors
Message
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00616414
Message ID:
00616431
Views:
25
>Does any one knows why this portion of code will generate the following error,
>
>strconn = "Initial Catalog=Soutiens;Data Source=CBCINC-SERVER;User ID=administrator;password=;"
>

I looks like you are having a problem opening your connection. Here is some C# code that I use to open a connection:
SqlConnection sobeConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;" + "Initial Catalog=Sobe");
sobeConn.Open();
SqlDataAdapter sobeDA = new SqlDataAdapter("SELECT * FROM Links", sobeConn);
Note that I am using Integrated (Windows) security. You should double check that the database exists, the server name is correct, and the user/password. Is the user in the roles setup for that database?

-Dave
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform