princessk1
Programmer
I am trying to set up an ODBC connection but am having problems with the syntax. Does any one have any sample code for this? Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC Connection problems
- Thread starter princessk1
- Start date
- Status
Here is one way, using a DSN-Less Connection -
This one is for Oracle but general syntax is the same for most..
hth
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
This one is for Oracle but general syntax is the same for most..
Code:
<%
Dim objDC, objRS
' Create and establish data connection
Set objDC = Server.CreateObject("ADODB.Connection")
objDC.ConnectionTimeout = 15
objDC.CommandTimeout = 30
'Code to connect to Oracle Warehouse
objDC.Open "Provider=MSDAORA.1;Password=yourpass;User ID=yourid;Data Source=tnsnamesentryhere;Persist Security Info=TRUE"
%>hth
- Status
Similar threads
- Locked
- Question
