{"id":2369,"date":"2012-12-06T11:28:07","date_gmt":"2012-12-06T15:28:07","guid":{"rendered":"http:\/\/www.iowawebnet.com\/ein\/?p=2369"},"modified":"2012-12-07T12:01:05","modified_gmt":"2012-12-07T16:01:05","slug":"classic-asp-connection-string","status":"publish","type":"post","link":"https:\/\/www.iowawebnet.com\/ein\/2012\/12\/classic-asp-connection-string\/","title":{"rendered":"Classic ASP Connection String"},"content":{"rendered":"<pre>\r\nSql connection\r\n************************\r\n<code>\r\nDim connStr\r\nconnStr = \"Provider=SQLOLEDB;Data Source=my-sql-server;UID=MyUsernmame;\r\n           PWD=MyPassword; database=MyDatabase;\"\r\n\r\nSet objConn = Server.CreateObject(\"ADODB.Connection\")\r\nobjConn.ConnectionTimeOut = 30\r\nobjConn.ConnectionString = connStr\r\nobjConn.Open\r\nSET objRS = Server.CreateObject(\"ADODB.RecordSet\")\r\nobjRS.Open \"SELECT * FROM my_table ORDER BY type asc\",objConn,1,2\r\n\r\n'do some sql work\r\n\r\n     objRS.Close\r\nSET objRS = Nothing\r\n<\/code>\r\n\r\nAccess 2007\/2010 connection\r\n************************\r\n<code>\r\nDIM objConn, objRS, dsn, dbPath\r\ndsn = \"Driver={Microsoft Access Driver (*.)};Dbq=C:\\MyWebsite\\databases\r\n       \\MyDatabase2007.accdb;\"\r\n\r\nSet objConn = Server.CreateObject(\"ADODB.Connection\")\r\n    dbPath = Server.MapPath(\"MyDatabase2007.accdb\")\r\n    objConn.Open \"Microsoft.ACE.OLEDB.12.0;Data Source=\" & dbPath, \"\", \"\"\r\nSET objRS = Server.CreateObject(\"ADODB.RecordSet\")\r\n    objRS.Open \"SELECT * FROM my_table ORDER BY id asc\",objConn,1,2\r\n\r\n'do some sql work\r\n\r\n     objRS.Close\r\nSET objRS = Nothing\r\n<\/code>\r\n\r\nAccess 2003 connection\r\n************************\r\n<code>\r\nDIM objConn, objRS, dsn, dbPath\r\ndsn = \"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\MyWebsite\\databases\r\n       \\MyDatabase2003.mdb;\"\r\n\r\nSet objConn = Server.CreateObject(\"ADODB.Connection\")\r\n    dbPath = Server.MapPath(\"MyDatabase.mdb\")\r\n    objConn.Open \"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\" & dbPath, \"\", \"\"\r\nSET objRS = Server.CreateObject(\"ADODB.RecordSet\")\r\n    objRS.Open \"SELECT * FROM my_table ORDER BY id asc\",objConn,1,2\r\n\r\n'do some sql work\r\n\r\n     objRS.Close\r\nSET objRS = Nothing\r\n<\/code>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Sql connection ************************ Dim connStr connStr = &#8220;Provider=SQLOLEDB;Data Source=my-sql-server;UID=MyUsernmame; PWD=MyPassword; database=MyDatabase;&#8221; Set objConn = Server.CreateObject(&#8220;ADODB.Connection&#8221;) objConn.ConnectionTimeOut = 30 objConn.ConnectionString = connStr objConn.Open SET objRS = Server.CreateObject(&#8220;ADODB.RecordSet&#8221;) objRS.Open &#8220;SELECT * FROM my_table ORDER BY type asc&#8221;,objConn,1,2 &#8216;do some sql work objRS.Close SET objRS = Nothing Access 2007\/2010 connection ************************ DIM objConn, objRS, dsn, dbPath dsn = [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28,17,33,32],"tags":[30,34,123,146],"class_list":["post-2369","post","type-post","status-publish","format-standard","hentry","category-access","category-applications","category-classic-asp","category-ms-sql","tag-access-2","tag-classic-asp-2","tag-connection-string","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2369"}],"collection":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/comments?post=2369"}],"version-history":[{"count":10,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2369\/revisions"}],"predecessor-version":[{"id":2382,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/posts\/2369\/revisions\/2382"}],"wp:attachment":[{"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/media?parent=2369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/categories?post=2369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iowawebnet.com\/ein\/wp-json\/wp\/v2\/tags?post=2369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}