Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-14-2012, 04:25 AM
tinfanide tinfanide is offline ADODB.Connection.Open Provider? Windows 7 64bit ADODB.Connection.Open Provider? Office 2010 32bit
Expert
ADODB.Connection.Open Provider?
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default ADODB.Connection.Open Provider?

Code:
Sub test()

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset

Dim ConStr As String
ConStr = "Provider=sql100.xtreemhost.com;Server=sql100.xtreemhost.com;Database=myDatabase;Uid=xth_9595110;Pwd=myPassword"

Dim sql As String
sql = "select * from myTable"

''' Application-defined or Object-defined error
cn.Open ConStr

rs.Open sql, cn

MsgBox rs("Headings")

rs.Close
cn.Execute sql
cn.Close

End Sub
In MySQL scripting, I only do this and it can work:
Code:
$connect = mysql_connect("sql100.xtreemhost.com","xth_9595110","myPassword") or die(mysql_error());

mysql_select_db("myTable",$connect);
I wonder if my connection string is wrong.
If I'm using xtreemhost SQL server
What is the provider? What is the server?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL ADODB.RecordSet Error 91 marreco Excel Programming 2 05-02-2012 04:43 PM
Best Mobile Service Provider! Nethrom Outlook 0 11-14-2011 02:10 PM
Outlook PRF settings for TLS encrypted connection scsawwfca Outlook 0 05-19-2011 05:32 AM
vba for point of connection in a shape chinkygogo PowerPoint 2 01-03-2011 03:40 AM
how to install MS Project OLEDB Provider pascali Project 0 02-24-2006 07:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft