Connecting to Tandem SQL / MX thru win2000 server by ASP.NET

[selamiozlu]

Connecting to Tandem SQL / MX thru win2000 server by ASP.NET

Hi all,
I have windows 2000 server pc and i am running a project in asp.net.
I want to connect to a remote tandem server which runs sql/mx database server.

I installed odbc/mx1.8 on my pc. it tests ok.

But when i try to connect to the server thru ASP.NET i could not.

What should my connection string look like?

Thank you.

[mmetzger]

Easiest thing to do is create a new document on the desktop and name it test.udl (make sure you're showing file extensions.) Double click on it and it should open the ODBC Connection dialog. Connect to the database accordingly. Once everything checks out, choose ok and close the wizard. Once closed, open the udl file in a text editor. There's your connect string.

Now, one note is if you're using Windows authentication, you must make sure the IIS account has access to the database. As such, it's smarter to use database oriented authentication.