Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File DSN Connection
Message
De
23/04/2002 02:17:07
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
File DSN Connection
Divers
Thread ID:
00647993
Message ID:
00647993
Vues:
42
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.com
Success 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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform