?
Solved

Connection String for Classic ASP to SQL Server 2008

Posted on 2009-05-18
5
Medium Priority
?
8,784 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

649 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