Hello group,


I am having troubles connecting to a SQL Server for our web site. The SQL
Server is running on a separate box from the web server. I have created a
DSN link to the SQL Server and tested it and all is great.

When I go to run the ASP pages within the site, all is not great. I get a
host of different errors when I fool with the Connection script.

Here is the script:

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_careers_STRING = "dsn=careers;"
%>

The error can be viewed if you go to
www.mncareers.org/start_exploring.asp?pageid=se01

I believe I need a user id and password added, which I have tried, but came
up with other errors. Is there anything I am missing?

Please feel free to email me directly at

Thank you in advance for your help,

Clint Pidlubny

what are the errors when you use a username and password?

Keith Slater

Try changing to this
MM_careers_STRING = "dsn=careers;uid=TypeYourUserNameHere;pwd=TypeYourPasswordHere;"

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello group,


I am having troubles connecting to a SQL Server for our web site. The SQL
Server is running on a separate box from the web server. I have created a
DSN link to the SQL Server and tested it and all is great.

When I go to run the ASP pages within the site, all is not great. I get a
host of different errors when I fool with the Connection script.

Here is the script:

&lt;%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_careers_STRING = "dsn=careers;"
%&gt;

The error can be viewed if you go to
www.mncareers.org/start_exploring.asp?pageid=se01

I believe I need a user id and password added, which I have tried, but came
up with other errors. Is there anything I am missing?

Please feel free to email me directly at

Thank you in advance for your help,

Clint Pidlubny

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

That was the fix. I was trying ot get to complicated when I was trying it. It was simple, I knew it would be and you showed me the way.

I thank you and the state of Minnesota thanks you.

Clint Pidlubny