Printable View
Hello everyone
I searched planet source code for a code that create a System ODBC
but all codes are doing ODBCs that asks for user name and password
I want the authenticity with Windows NT authentication using the network login ID
how can I do this ?
Thanks
Why do you need ODBC? You can use ADO code to connect without having the overhead and aggravation of ODBC setup.
Because the SQL Server is used by many clients on the network, an ODBC Connection setup needed to connect to the server.
If this is just for your VB program, it isn't needed at all (and is arguably a bad idea anyway).
See the Connection Strings link in my signature for examples of what you need to connect without DSN's.
I need to know how to create a system dsn regardless of it is a bad idea, I need to know how.
Well I suggest you search the forums for the code, as most of us stopped using DSN's years ago.
ty sir
I wrote some code to lookup and create an ODBC once. It's all registry settings. Create an ODBC yourself the way you want, then check out the values in HKLM\SOFTWARE\ODBC\... under the DSN name you created.
You do need to know the path to the driver that is being used, i.e. full path to sqlsrv32.dll for sql server, as it is one of the registry values. If you really want code, I can post what I've got.
this will create a DSN
VB Code:
Wow. I wish I knew that 5 years ago! What object is rdoEngine from (remote data objects?)
I use an ODBC when connecting to our AS400, Do you still need some help?
can you post the codes that connecting/creating ODBC for AS400
All the code I found, located, created is in my signature...I wrote ? 2004?Quote:
Originally Posted by ganeshmoorthy
With the correct use -profile and password...it should work
Glad to help
MLS