#1
|
|||
|
|||
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 Code:
$connect = mysql_connect("sql100.xtreemhost.com","xth_9595110","myPassword") or die(mysql_error()); mysql_select_db("myTable",$connect); If I'm using xtreemhost SQL server What is the provider? What is the server? |
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 |