Suche

Public Const ODBC_ERROR_GENERAL_ERR = 1
Public Const ODBC_ERROR_INVALID_BUFF_LEN = 2
Public Const ODBC_ERROR_INVALID_HWND = 3
Public Const ODBC_ERROR_INVALID_STR = 4
Public Const ODBC_ERROR_INVALID_REQUEST_TYPE = 5
Public Const ODBC_ERROR_COMPONENT_NOT_FOUND = 6
Public Const ODBC_ERROR_INVALID_NAME = 7
Public Const ODBC_ERROR_INVALID_KEYWORD_VALUE = 8
Public Const ODBC_ERROR_INVALID_DSN = 9
Public Const ODBC_ERROR_INVALID_INF = 10
Public Const ODBC_ERROR_REQUEST_FAILED = 11
Public Const ODBC_ERROR_INVALID_PATH = 12
Public Const ODBC_ERROR_LOAD_LIB_FAILED = 13
Public Const ODBC_ERROR_INVALID_PARAM_SEQUENCE = 14
Public Const ODBC_ERROR_INVALID_LOG_FILE = 15
Public Const ODBC_ERROR_USER_CANCELED = 16
Public Const ODBC_ERROR_USAGE_UPDATE_FAILED = 17
Public Const ODBC_ERROR_CREATE_DSN_FAILED = 18
Public Const ODBC_ERROR_WRITING_SYSINFO_FAILED = 19
Public Const ODBC_ERROR_REMOVE_DSN_FAILED = 20
Public Const ODBC_ERROR_OUT_OF_MEM = 21
Public Const ODBC_ERROR_OUTPUT_STRING_TRUNCATED =
22
’API Command to create a Data Source Name, not used
in this example
Public Declare Function SQLCreateDataSource Lib
"odbccp32.dll" (ByVal hwnd&, ByVal lpszDS$) As
Boolean
’API to modify/Edit/Create a Data Source Name
Public Declare Function SQLConfigDataSource Lib
"odbccp32.dll" (ByVal hwnd As Long, ByVal fRequest
As Integer, ByVal lpszDriver As String, ByVal
lpszAttributes As String) As Boolean
I have also put together a Project with this very code you can
download it here.
http://www.kb244.com/Downloads/
Any Comments/Sugestions/Questoins email me at
[e-mail]
4 von 5
07.01.02 10:13