2 Replies - 1360 Views - Last Post: 16 June 2011 - 02:26 AM

#1 reCoded  Icon User is offline

  • D.I.C Regular

Reputation: 6
  • View blog
  • Posts: 282
  • Joined: 25-February 08

Trouble with connection string for ASP page

Posted 15 June 2011 - 08:07 AM

Hi all,

I am having trouble connecting to oracle from my asp page. This is what I have.

set conn = Server.CreateObject("adodb.connection")

conn.ConnectionString = "Provider=SQLOLEDB;Data Source=fintest;Initial Catalog=rss;User Id=blah;Password=blah"
		

conn.Open





I get "Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."

also tried
"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=aora)(PORT=1555)))(CONNECT_DATA=(SERVICE_NAME=blah.blah.blah))); User Id=user; Password=password; Pooling=true; Min Pool Size=5; Max Pool Size=25; Incr Pool Size=5; Decr Pool Size=5; Connection Lifetime=120"/>



And I get an error saying the connection string is too long... I dont know what else to do. This is an asp page trying to connect to oracle... Ugh any help would be great thanks.

Is This A Good Question/Topic? 0
  • +

Replies To: Trouble with connection string for ASP page

#2 SurfingShark  Icon User is offline

  • D.I.C Head

Reputation: 38
  • View blog
  • Posts: 188
  • Joined: 18-April 11

Re: Trouble with connection string for ASP page

Posted 15 June 2011 - 07:48 PM

It looks by that error you don't have access to the database. Did you try manually hitting it with your credentials to ensure that access is possible?

As for the connection string, check out: http://www.connectionstrings.com/
Was This Post Helpful? 0
  • +
  • -

#3 eclipsed4utoo  Icon User is offline

  • Not Your Ordinary Programmer
  • member icon

Reputation: 1524
  • View blog
  • Posts: 5,960
  • Joined: 21-March 08

Re: Trouble with connection string for ASP page

Posted 16 June 2011 - 02:26 AM

Since this is Classic ASP instead of ASP.Net, I am moving to the Web Development forum.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1