Trying to get ODBC Connection without manual intervention

[SercoSteve]

I am attempting to connect to a Server using ODBC from a Paradox 8 Script. The script runs fine and connects to the server, however the first thing it does is display a dialog box requesting server information. I dont need to enter the information I just hit <CR> and it connects successfully.

Does anybody know a way of connecting to a server, using ODBC, without displaying the dialog box? The script is going to run as a sheduled task on my machine, when complete, and must be free of manual intervention.

Thanks in advance.

Steve

 

[softlad]

Hi

HAve you included the server in your connection script?

ie: strConn = &quot;driver={SQL Server};&quot; & _
&quot;server=RSGCODA01;uid=cadenzaprod;pwd=cadenzaprod;data base=cadenzaprod&quot;

I use this and it connects fine!!

Paul