Re: ASP ODBC and Oracle

> I made some test a month ago with SQL server and everything worked fine. Now I
> have an Oracle 7.3 Server, trying to do the same thing with Active Server
> Page.
>
> My simple ASP pageas these lines:
>
> <% set myconnection = server.createobject ("adodb.connection") %>
> <% myconnection.open "sourcedsn","auser","apsswd" %>
>
> And after that line it stops!
>

try this instead:

<% myconnection.open
"dsn=ODBC_DEVICE_NAME_HERE;uid=DATABASE_ACCOUNT_NAME_HERE;pwd=PASSWORD_HERE" %>

replacing the descriptive text with the actual values, ie. if the password is fred, then it's pwd=fred not pwd=PASSWORD_HERE

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet