How to connect ASP to different database

**Elijah2010** · 15-02-2010

Hi all,

I am a programmer and building a project on the medical system. I need to help in my project that problem in connecting with database. I want to test the program will different database. Please suggest me how to connect the ASP with different database. Thanks in advance.

**Modifier** · 15-02-2010

I have connect the ASP to access database with below connectivity coding.

Code:

set adocon = Server.Createobject ( "adodb.connection123")
adoconn.Open "Driver = (Microsoft Access Driver (*. mdb)); DBQ =" & _
Server.MapPath ( "database, where the path")

It is Access database DSN ess connection methods. Check and reply.

**MindSpace** · 15-02-2010

I have connect the ASP to SQL by below coding. It is helpful to you for connecting the ASP to SQL.

Code:

set adocon = Server.Createobject ( "adodb.connection123")
adocon.open "provider = SQLOLEDB.1; Data Source = my data 123;" & _
"user ID =*****; Password =******;"& _
"inital Catalog = database name123"

Check and reply.

**opaper** · 15-02-2010

If you want to connecting your database by Oracle 9i. The connection method is below:

Code:

set adocon = Server.Createobject ( "adodb.connection123")
adocon.open "Driver = (microsoft odbc for oracle); server = oraclesever.world123; 
uid = admin; pwd = pass;"

Best of luck.

**Reegan** · 15-02-2010

If you are using MYSQL as a database, this connection code are followed :

Code:

set adocon = Server.Createobject ( "adodb.connection")
adocon.open "Driver = (mysql); database = yourdatabase;
uid = id; pwd = password; option = 16386; "

Check and reply.

**Zecho** · 16-02-2010

If you want to use MS text OLE DB connection methods. Check the below :

Code:

set adocon123 = Server.Createobject ( "adodb.connection123")
adocon123.open "Provider = microsof.jet.oledb.4.0; data source = C:/myname/myfile.xls;" & _
"Extended Properties'text; FMT = Delimited '"

Check and reply.