Solved

MS ADO Connection string to Sun One ADO Connection string

Posted on 2004-07-31
10
721 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

820 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