Personal Mind of ASEP

Sepercik Rasa yang Tercurah

Koneksi ke db di asp

ini code berbagai koneksi ke database pake ASP yang gw salin dari snitz_forums_2000 lumayan deh buat kapan2 kalo lupa khan bisa diliad

‘strConnString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & Server.MapPath(“snitz_forums_2000.mdb”) ‘## MS Access 2000 using virtual path

‘strConnString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=” & Server.MapPath(“/USERNAME/db/snitz_forums_2000.mdb”) ‘## MS Access 2000 on Brinkster

‘strConnString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb” ‘## MS Access 2000

‘strConnString = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=” & Server.MapPath(“snitz_forums_2000.mdb”)

‘## MS Access 97 using virtual path

‘strConnString = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=” & Server.MapPath(“/USERNAME/db/snitz_forums_2000.mdb”) ‘## MS Access 97 on Brinkster

‘strConnString = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb” ‘## MS Access 97

‘strConnString = “Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;” ‘## MS SQL Server 6.x/7.x/2000 (OLEDB connection)

‘strConnString = “driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME” ‘## MS SQL Server 6.x/7.x/2000 (ODBC connection)

‘strConnString = “driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME” ‘## MySQL w/ MyODBC v2.50

‘strConnString = “driver={MySQL ODBC 3.51
Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;” ‘##MySQL w/ MyODBC v3.51
‘strConnString = “DSN_NAME” ‘## DSN
source : snitz_forums_2000

October 17, 2005 - Posted by | Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: