Information générale
Catégorie:
Fonctions Windows API
Titre:
How to Create a New ODBC DSN
I'm trying to discover how to create a NEW
ODBC Data Sources Using SqlConfigDataSource
*] First I use the Declare DLL function
DECLARE Integer SQLConfigDataSource in odbccp32.dll Integer, Integer,;
String, String
*] Then I create a string containing the settings to the driver I'm using
settings="DSN=TestVFP"+chr(0)+;
"Description=NEW_DSN_SQL7"+chr(0)+;
"Server=Pro200"+chr(0)+;
"SourceDB=C:\mssql7\data\policia.MDF"+chr(0)+;
"SourceType=MDF"+chr(0)+;
"UID=Peter"
y = SQLConfigDataSource(0,1,"TestVFP",settings)
Problem: Which are the apropriate settings to create a NEW ODBC System DSN to connect from my Fox application to SQL Server 7.0.
Could someone Help me please, with the correct
seetings and the order of those settings.
Thank's in Advance..
Peter Wagner
pointinfo@limeira.com.br
Brazil - SP - Limeira
* "DRIVER={SQL Server};Exclusive=No;SourceType=MDF;Deleted=No;
* SourceDB=C:\mssql7\data\policia.MDF;Server=Pro200;UID=Peter;pwd=123"
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement