Solved

Connection String for Classic ASP to SQL Server 2008

Posted on 2009-05-18
5
8,716 Views
Last Modified: 2012-06-27
I am trying to use ASP code to connection to a SQL Server 2008 instance.  The Web server and Database server are separate machines.  We have some ASP.NET code with connection strings in a web.config file that works fine.  But when I try the same connection strings with classic ASP I get an error saying:
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "

Below is the working ASP.NET string.  And some of the classic ASP strings I've tried with no luck.
My guess is that it is something with the server address being:
192.168.76.101\theServer
Can I combine IP address with server name like that?  If not, I don't have a named pipes name for this server that I know of.
WORKING:
<add name="FF_D1" connectionString="Data Source=192.168.1.55\theserver;Initial Catalog=SE_D1;Persist Security Info=True;User ID=CoAdmin;Password=Mypass2001"
          providerName="System.Data.SqlClient" />
 
Error in Classic ASP:
ConnString = "Data Source=192.168.1.55\theServer;Initial Catalog=SE_D1;Persist Security Info=True;User ID=CoAdmin;Password=Mypass2001"
 
I've also tried this:
 ConnString = "Driver={SQL Server};Data Source=192.168.1.55\theServer,1433;Network Library=DBMSSOCN;Initial Catalog=SE_D1;User ID= CoAdmin;Password=Mypass2001;"
 
With this one I get the error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
 ConnString = "Driver={SQL Server};Server=192.168.1.55\theServer;Database=SE_D1;Uid=CoAdmin;Pwd=Mypass2001;"

Open in new window

0
Comment
Question by:Thread7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24418517
All connection strings for SQL Server 2008 here:

http://www.connectionstrings.com/sql-server-2008

Kindly select the appropriate connection string based upon your Client or provider
0
 
LVL 1

Author Comment

by:Thread7
ID: 24422447
I've tried just about all these Connection Strings with no luck.  
Remember I CAN connection with ASP.NET code.
I cannot simply create an ODBC system or user DSN through Control Panel.  I am thinking it is because the OS on the web server is just a standard Windows 2003.  There hasn't been anything else installed.  Therefore maybe I need sql 2008 drivers?  But then why does ASP.NET connect fine?

0
 
LVL 4

Expert Comment

by:CoveyCraig
ID: 24511651
You can connect using the TCP/IP method with classic ASP.

Use this format, it'll work.

Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
0
 
LVL 1

Accepted Solution

by:
Thread7 earned 0 total points
ID: 25044794
Nope.  Looks like my Win 2003 Server didn't have a SQL 2008 (SQL10) driver that it needs.
0
 
LVL 4

Expert Comment

by:shrikantss
ID: 27448466
0
  i got the solution................ for classical asp connection string is
myConnection.ConnectionString = "Driver={SQL Server};Server=xxx.xxx.xxx.xxx,1533;Database=mydb;Uid=user123;Pwd=user123d;"
it will surely work dont u worry for anything..............
 
0

Featured Post

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question