Hi,

With SQL you normally have to set a user name and password to open. You will
have to find this on your SQL server.

For all other connection problems you should find it more or less covered in
VB6 Databases by Charles Williams (Wrox Press).

Hoping this will help,

Richard Wang

----- Original Message -----
From: <jon.holyoake@m...>
To: professional vb <pro_vb@p...>
Sent: Wednesday, June 07, 2000 4:49 PM
Subject: [pro_vb] accessing SQL ODBC database using VB


> hi my problem is i created a program that used a access database only to
> find out that it needs to be used with a SQL database on ODBC at the
moment
> i am accessing the database using
>
> Data2.RecordSource = "select * from winners where competition = " & comp
> Data2.Refresh
>
> i change the properties to useODBC instead of useJET  and i rename the
> database name to the ODBC name but it keeps asking me for username and
> password (which i have but dont know how to incorporate it in the code)
>
> also the connect type doesnot list SQL database????
>