Hi All,
Definitely new to a Mac and am really confused as to how to use the ODBC functions... I have a macro that I am building to access a sql table, however I am not sure of the syntax to use....
This is where I am going wrong (I think)
Public strConnection As String
Public oCon As New ADODB.Connection
Public rsSec1 As New ADODB.Recordset
Public Counter As Double
Public StopCounter As Double
Public SQLFilter As String
Public SQL1 As String
Public strInput As String
Public Sub ServerCon()
Set oCon = New ADODB.Connection
Set rsSec1 = New ADODB.Recordset
strConnection = "PROVIDER=SQLOLEDB;DATA SOURCE=IRP_prod;user id=I*****;password=i****;"
oCon.ConnectionTimeout = 60
oCon.Open strConnection
End Sub
Can anyone convert this so I can use it on a Mac??
Definitely new to a Mac and am really confused as to how to use the ODBC functions... I have a macro that I am building to access a sql table, however I am not sure of the syntax to use....
This is where I am going wrong (I think)
Public strConnection As String
Public oCon As New ADODB.Connection
Public rsSec1 As New ADODB.Recordset
Public Counter As Double
Public StopCounter As Double
Public SQLFilter As String
Public SQL1 As String
Public strInput As String
Public Sub ServerCon()
Set oCon = New ADODB.Connection
Set rsSec1 = New ADODB.Recordset
strConnection = "PROVIDER=SQLOLEDB;DATA SOURCE=IRP_prod;user id=I*****;password=i****;"
oCon.ConnectionTimeout = 60
oCon.Open strConnection
End Sub
Can anyone convert this so I can use it on a Mac??