Solved

MS ADO Connection string to Sun One ADO Connection string

Posted on 2004-07-31
10
711 Views
Last Modified: 2011-09-20
Hi, I am using the following format, which works in a stand-alone  VB 6 application.

         
cnn.Open "Driver={SQL Server};" & _
           "Server=server.ip.com;" & _
           "Address=server.ip.com,1433;" & _
           "Database=dbname;" & _
           "Uid=dbuser;" & _
           "Pwd=dbpass"

When I try using this wtih the Sun One ADO object, it complains.  The following is the error:

SQLState: 28000 Native Error Code: 4002 [DataDirect][ODBC SQL Server Driver][SQL Server] SQLState: 01S00 Native Error Code: 0 [DataDirect][ODBC SQL Server Driver]Invalid connection string attribute

Anyone know where to look?
0
Comment
Question by:Discofish
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 11685145
You can try this:

strConnectString = "Provider=sqloledb;Data Source=(local); initial catalog = DatabaseName; user Id= sa; password= yourpassword"

cnn.open strConnectString
0
 
LVL 1

Expert Comment

by:abombs
ID: 11685152
I've seen this posted alot:

http://www.able-consulting.com/ADO_Conn.htm
0
 
LVL 31

Expert Comment

by:alorentz
ID: 11685166
Also, 1433 is standard port, so probably don't need that, and probably don't need address -

cnn.Open "Driver={SQL Server};" & _
           "Server=ipaddress;" & _
           "Database=dbname;" & _
           "Uid=dbuser;" & _
           "Pwd=dbpass"
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 31

Expert Comment

by:alorentz
ID: 11685170
I think Address caused that error "Invalid connection string attribute"
0
 
LVL 2

Author Comment

by:Discofish
ID: 11685197
ok, when I take the address line out - this is what happens:

SQLState: S1000 Native Error Code: 11 [DataDirect][ODBC SQL Server Driver][libssclient18]General network error. Check your network documentation. SQLState: 01000 Native Error Code: 11 [DataDirect][ODBC SQL Server Driver][libssclient18]ConnectionOpen (,()). SQLState: 01S00 Native Error Code: 0 [DataDirect][ODBC SQL Server Driver]Invalid connection string attribute

Could it be that the drivers on the server are not configured properly?  I am using a  hosting account to try to connect to this database.

Note that I have connected to the DB from multiple IPs from the VB program I mentioned.

Let me know if there is anything else I can provide to help diagnose the problem
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 11685215
Any luck with the oledb solution I suggested? It is doubtful that it will fix your problem but will only take a minute to try.

FtB
0
 
LVL 2

Author Comment

by:Discofish
ID: 11685252
Fritz,

No luck
0
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 500 total points
ID: 11685278
Okay, the only other thing that I can offer if you haven't seen it is this:

http://swforums.sun.com/jive/thread.jspa?messageID=54158

http://docs.sun.com/source/817-2514-10/Ch8_BuildApp31.html

FtB
0
 
LVL 1

Expert Comment

by:abombs
ID: 11685291
What version SQL server is it?  Have you update your MDAC to 2.8?
0
 
LVL 2

Author Comment

by:Discofish
ID: 11685322
Ahh! Looks like I have to create a system DSN.  I will try this.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

786 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