≡ Menu

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:inetpubdbrootsnitz_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:inetpubdbrootsnitz_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

{ 1 comment… add one }

Leave a Comment

Next post:

Previous post: