Very Computer

by **Miroslaw Padjase** » Wed, 09 Oct 2002 23:12:36

Hi,
I am new to Visual Basic. I tried to initialize Adodc control from the code
to connect to the Access database using ODBC data source name.
So inside my Form_Load event I used the following code:
Adodc1.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Data Source=BazaKlienta"
Adodc1.RecordSource = "Bugs"
It works in a way because my data from bug table is displayed but
unfortunately I also get an error message "Data source name not found and no
default driver specified"
Can someone help?
Miroslaw

by **Val Mazu** » Wed, 09 Oct 2002 23:25:00

Hi,

When do you get that error?

--
Val Mazur
Microsoft MVP

Quote:> Hi,
> I am new to Visual Basic. I tried to initialize Adodc control from the
code
> to connect to the Access database using ODBC data source name.
> So inside my Form_Load event I used the following code:
> Adodc1.ConnectionString = "Provider=MSDASQL.1;Persist Security
> Info=False;Data Source=BazaKlienta"
> Adodc1.RecordSource = "Bugs"
> It works in a way because my data from bug table is displayed but
> unfortunately I also get an error message "Data source name not found and
no
> default driver specified"
> Can someone help?
> Miroslaw

by **Scot Ro** » Thu, 10 Oct 2002 02:47:20

Blank out the ConnectionString and RecordSource properties in the ADODC since you are setting them from code You could also try to execute your code in teh
Form_Initialize event but I have seen that fail on occasion. The most reliable way I have seen to avoid the error is to not have those properties set in the ADODC
in the first place. (Well the most reliable thing is to NOT use an ADODC and use ADO Code but thats something for another time)
____________________________________________________________________________

Scot Rose, MCSD
Microsoft Visual Basic Developer Support

This posting is provided AS IS, with no warranties, and confers no rights.

Want to know more? Check out the MSDN Library at http://msdn.microsoft.com
or the Microsoft Knowledge Base at http://support.microsoft.com

Perhaps your question has already been answered!!!!
Search for it first at http://groups.google.com

by **Miroslaw Padjase** » Thu, 10 Oct 2002 16:02:15

Quote:> Blank out the ConnectionString and RecordSource properties in the ADODC

since you are setting them from code You could also try to execute your code
in teh

Quote:> Form_Initialize event but I have seen that fail on occasion.

Thanks, it has worked.

The most reliable way I have seen to avoid the error is to not have those
properties set in the ADODC

I am learning Visual Basic and have to quickly put together something that
works. I will definitely use your suggestion if this project has to go to
any external customer and I will have more time to work on it.
Miroslaw

Very Computer

cannot initialize adodc control from the code

cannot initialize adodc control from the code

cannot initialize adodc control from the code

cannot initialize adodc control from the code

cannot initialize adodc control from the code