ADO Data Control Not working ...

[jfield817]

Everyone,

I placed an ADO control on the form and text box on the form, however I keep getting "Data Source name not found and
no default driver specified" when I run the following
in VB 6 .... I ran it with the DSN and without...

I am trying a simple connection to the Pubs database
in MSSQL Sever 7


Adodc1.ConnectionString = "Driver=(SQL Server);Server=Myserver; Database=pubs; Uid=username;Pwd=password"

Adodc1.RecordSource = "select * from titles"

Set Text1.DataSource = Adodc1
Text1.DataField = "title"

 

[MarkSweetland]

This happens to me if I put something in the RecordSource property of the ado control at Design time without specifing any connection string. Try removing whatever is in the RecordSource property and try again.


Mark The law, in its majestic equality, forbids the rich, as well as the poor, to sleep under the bridges, to beg in the streets, and to steal bread.

Anatole France