What's wrong with this?

[Ladyhawk]

What's wrong with this? I get a message saying that the data source name not found and not default driver not specified.

Dim x As New rdoConnection
Dim y As rdoQuery
x.Connect = "PROVIDER=SQLOLEDB;" & _
"DSN=LocalServer;DATABASE=viewer;" & _
"UID=sa;PWD=;"

x.EstablishConnection

Set y = x.CreateQuery("Query1", "SELECT * FROM GraphBenefitVsCost&quot

y.CursorType = rdOpenKeyset
y.LockType = rdConcurRowver
x.Query1
Set MSRDC1.Resultset = x.LastQueryResults
Ladyhawk.
** ASP/VB/Java Programmer **

 

[mgardiner]

Do you have a DSN named Local Server.
If not add one. depending on what operating system you are running this involves different steps. Let me know if you need more information.

 

[Ladyhawk]

Yes there is a dsn called LocalServer. It is automatically created by SQL Server. Ladyhawk.
** ASP/VB/Java Programmer **