07-24-2008, 05:30 PM
Hi,
That code looks perfectly fine for me.
If you srill having a problem that means check whether oracle client installed on your machine or not.
I live in London,UK.
or try the following connection string...
That code looks perfectly fine for me.
If you srill having a problem that means check whether oracle client installed on your machine or not.
I live in London,UK.
or try the following connection string...
Code:
strCon = "Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=hostname)(PORT=1526))" & _
"(CONNECT_DATA=(SID=sidname))); uid=report;pwd=report;