As said in a previous post, I am beginning to experiment with SQLServer,

using SQLServer 2005 Std Ed. on an XP Prof SP2 machine.

I managed to build my first edit form, using an ODBC connection.

I created an ODBC connection called MYCONNECTION, which uses the database

called TEST, and a table called CUSTOMERS.

if I use:

cConnString = 'MYCONNECTION'

and

nHandle = SQLConnect(cConnString)

the connection is succesful

If instead I use:

cConnString='Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security

Info=False;Initial Catalog=test;Data Source=RAFAELPC\SQLEXPRESS'

I have to use:

nHandle = SQLStringConnect(cConnString)

This opens a dialog forcing me to choose the MYCONNECTION ODBC source, and

then the connection succeeds.

Questions:

1) why does the above dialog appear and how can I get rid of it?

2) why does sqlconnect not work with the second connection string (the long

one)?

Can anyone give me the answers?

TIA

Rafael Copquin