>Hi Guys!
>
>I created a File DSN and named it as Conn_Static. I use SQL Passthrough to fetch data from remote database.
>
>My previous code goes like the one below.
>
>SQLCONNECT("bbfsdsn",pvUserid, pvUserpassword) to connect to the database. bbfsdsn is a system DSN that I made in the ODBC Connections.
>
>How can I use the file DSN to connect to the database using SQL Passthrough.
>I tried the code below but does not work.
>
>SQLCONNECT("Conn_Static", pvUserid, pvUserpassword)
>
>Any Idea?
>
>Thanks in advance.....
Mike,
I think you'd be more comfortable if you use SQLStringConnect() instead. ie:
lnHandle=SQLStringConnect('DRIVER=SQL Server;SERVER='+;
tcServerName+;
';DATABASE='+tcDefaultCatalog+;
';UID='+tcUserId+';PWD='+tcPWD)
Cetin