how to connect a remote mssql database in PB?
Posted: Sun Feb 11, 2007 9:58 am
how to connect a remote mssql database in PB?
anybody can help me?
anybody can help me?
On a windows system you can use the ODBC driver provided by M$. On my XP its installed as default. You just need to go to your ODBC configuration tool and set up a user DNS for this.
After that, you can use OpenDatabase() to connect to the server.
If you want to create the ODBC connection withing your code, just do a search on the purearea.net .
http://www.purearea.net/pb/CodeArchiv/D ... the-fly.pb
I think this is what you are searching for.