Here is my code:
Msgbox(0,"","Start the Script and load the error handler")
_SQLRegisterErrorHandler();register the error handler to prevent hard crash on COM error
$con = _SQLStartup()
If @error then Msgbox(0,"Error","Error starting ADODB.Connection")
;Create a database
_sqlConnect(-1,"localhost","C:\SiteManagerDB.db","","")
if @Error then _DisplayError($SQLErr)
_SQLClose()
Func _SQLConnect($ConHandle,$server, $db, $username, $password)
DIM $SQLErr
If $ConHandle = -1 then $ConHandle = $sqlLastConnection
$ConHandle.Open ("DRIVER={SQL Server};SERVER=" & $server & ";DATABASE=" & $db & ";uid=" & $username & ";pwd=" & $password & ";") ;<==Connect with required credentials
If NOT @error then return 1
Return SetError(1,0,0)
EndFunc
If I specify DRIVER={SQL Server}, I receive this error: "[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist or access denited."
If i specify DRIVER={SYBASE SYSTEM 11}, I receive this error: "[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified."
Can you expand this?