Search DaniWeb - sqlconfigdatasource

DSN in Windows 7 13 Years Ago by jhai_salvador … & "DBQ=" & MDBPath & Chr$(0) intRet = SQLConfigDataSource(vbAPINull, ODBC_ADD_SYS_DSN, _ strDriver, strAttributes) ' DSN created End Sub [/CODE… Re: how do I connect to SQL with c++ 14 Years Ago by Frederick2 …,szDBName); printf("szCreate=%s\n",szCreate); if(SQLConfigDataSource(0,ODBC_ADD_DSN,"Microsoft Access-Treiber (*.mdb)",szCreate)) …{ printf("SQLConfigDataSource() returned TRUE\n"); return TRUE; } else { InstallerError();… Re: how do I connect to SQL with c++ 14 Years Ago by Frederick2 …,szDBName); printf("szCreate=%s\n",szCreate); if(SQLConfigDataSource(0,ODBC_ADD_DSN,"Microsoft Access-Treiber (*.mdb)",szCreate)) …{ printf("SQLConfigDataSource() returned TRUE\n"); return TRUE; } else { InstallerError();… Re: C++ and General Database apps 13 Years Ago by Frederick2 … a Microsoft Access Database from { //scratch, you use SQLConfigDataSource(). I TCHAR szCreate[256]; //believe if the database already…;CREATE_DB=")); //'11'. _tcscat(szCreate,szDBName); if(SQLConfigDataSource(0,ODBC_ADD_DSN,_T("Microsoft Access Driver (*.mdb)"… Re: Foxpro database 11 Years Ago by TnTinMN …/access-help/initializing-the-dbase-database-driver-HP001032158.aspx 'see: SQLConfigDataSource (dBASE Driver) ' http://msdn.microsoft.com/en-us/library/windows… Re: Making an ODBC Application 11 Years Ago by androidz … = Attr & "TRUSTED_CONNECTION=YES" & Chr(0) iReturn = SQLConfigDataSource(0, 1, "SQL Server", Attr) '-- i got a… Re: Making an ODBC Application 11 Years Ago by john.knapp …'re then passing a SQL Authentication UserID & password... (Source: SQLConfigDataSource attributes [here](http://msdn.microsoft.com/en-us/library/aa177860… Re: Making an ODBC Application 11 Years Ago by john.knapp … using a DLLImport statement to reference the WinAPI call for SQLConfigDataSource(), right? Can you post your Platform Invoke statement please? It… Re: Making an ODBC Application 11 Years Ago by john.knapp … UID or PWD are valid Key/Value pairs (attributes) in SQLConfigDataSource(). I can change my attributes to use `TRUSTED_CONNECTION=NO` and… Re: Making an ODBC Application 11 Years Ago by john.knapp … UID & PWD pair - which is *apparently not supported* by `SQLConfigDataSource()`. Alternatively, if you **have** to use SQL Security (users are… Re: Making an ODBC Application 11 Years Ago by john.knapp Bump... SQLDriverConnect looks to be the way to go. SQLConfigDataSource() will **not** accept the UID/PWD key value pair, and … Re: DSN in Windows 7 13 Years Ago by jhai_salvador :-O ow.. Nobody replies yet.. Okay, I have updated the code and used DAO 2.5 / 3.51 instead of the API, I also attached a sample VB6 app with a compiled version and an Access 2007 database so it can be tested. Please test this application on your WINDOWS 7. This will just create an ODBC connected, and thats it. I just want to know if this … Re: DSN in Windows 7 13 Years Ago by jhai_salvador Still no replies.. :sad: Please test the previously attach vb6 project in Windows 7, and Vista so I have an idea if it works or not..