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.....
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.