Hi Dave,

Actually, with the « server explorer », I can access the table with out any trouble.

And the connectstring is as follow,

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=administrator;Initial Catalog=Soutiens;Data Source=CBCINC-SERVER;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CBCINC-XP;Use Encryption for Data=False;Tag with column collation when possible=False

I did try this one also with the same error.

One thing I did notice is the fact the driver property is equal to this,

Microsoft OLE DB Provider for SQL Server

Is there anything special to do, to force the connection to be ADO.NET my server being SQL server 2000 (Version 8.00) ??

From one book I have VB.NET pro, they mention that ADO.NET will not use the entry « provider = » when ADO is in effect ??

I will try your code and let you know.

Thanks for the reply…

Carl





>>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