Archive

Posts Tagged ‘ADODB’

Database Connections in ASP

September 24th, 2009 Mehmatrix No comments


1.1) MSSQL ( Microsoft SQL Server ) Connection in ASP


Sturcture 1.1:

1
2
3
4
< %
Set ConnectionName=Server.CreateObject("Adodb.Connection")
ConnectionName.Open "driver={SQL Server};server=MyHost;uid=MyLogin;pwd=MyPassword;database=MyDatabaseName"
%>

You can determine the server, uid, pwd and database variables as you need.

Example 1.1:

1
2
3
4
< %
Set MyConn=Server.CreateObject("Adodb.Connection")
MyConn.Open "driver={SQL Server};server=127.0.0.1;uid=memisologin;pwd=memiso;database=memisodb"
%>

1.2) MDB ( Microsoft Access Database ) Connection in ASP

Click to Read Complete Article »

Bookmark and Share
Categories: ASP Tags: , , , , , , , ,
eXTReMe Tracker