Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
firejackmusic
Starting Member
15 Posts |
 Posted - 2009-07-16 : 04:22:20
|
I have an open connection that flagging a error - t dont know why though?function openDB() Dim connstring set connTemp=server.createobject("ADODB.connection") connstring = "Driver={SQL Server};Server=CARILON\SQLEXPRESS;UID=sa;PWD=******;Database=cq" connTemp.Open connstring if err.number <> 0 then 'response.redirect "pt_supporterror.asp?error="&Server.Urlencode("Error "&err.number&" while opening DB:"&Err.Description& "<br><br><b>Common solutions</b><br><br>1. Check that your web server has Access 97 or 2000 ODBC installed <br>2. Check that you have read, modify and delete permissions over database folder and database file <br>3. Open your database with Access program and select Repair Database option <br>4. Select other connection method like other connection string or DSN") end if end function |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-16 : 15:09:06
|
| what's the error msg?try conn string like this:"Provider=SQLNCLI.1;Persist Security Info=False;Initial Catalog=cq;Data Source=CARILON\SQLEXPRESSUID=sa;PWD=******" |
 |
|
|
firejackmusic
Starting Member
15 Posts |
Posted - 2009-08-14 : 06:30:25
|
| Provider worked brilliant |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-14 : 10:04:52
|
glad to hear it  |
|
|
|
|
|
|
Object required