ODB databases and ASP

[Phonez]

Does anyone know if it is possible to connect to an ODB database within ASP. You can define an ODBC connection and try to connect to that but I cannot find any examples of the code that needs to be used to do this.

Any help would be appreciated

Thanks,

Jon

 

[bigozz]

Set up the ODBC connection on the server, then when you open your ADO Connection use a connection string like:-

set dCon = CreateObject("ADODB.Connection&quot

dConn.open "Provider=MSDASQL.1;Persist Security Info=False;User ID=[userid];Data Source=[name of ODBC name]"

Hope i read you're problem right.

 

[Phonez]

The database has been created in Oracle 8i lite. I have set up an ODBC connection but the code is still a bit of a problem. I have managed to get dreamweaver ultradev to recognize the table and connect to it but I cannot see anywhere in the code the connect string that it uses.

Any help would be appreciated

Thanks

 

[v0520]

Yes, it depends upon what ole-db provider you are using (I am assuming you are using ado). If you are using the odbc api, then your code would have to know the correct odbc connect string and if you have a dsn, that would have to be configured correctly, such as ip address of the database server, ip port etc.

Try looking at this link.

http://www.able-consulting.com/ado_conn.htm

It has lots of different examples of connecting to different ole-db providers and odbc.

Gilbert M. Vanegas
Programmer Analyst III
County of San Bernardino - ISD
Email : gvanegas@isd.sbcounty.gov

 

[Phonez]

Thats great thanks!