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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-18 : 18:50:40
|
michael writes "Hi
getting the following error 800a0bb9 from ODBC when using this code:
dim sConnString, MySQL
dim connLogin
dim rsLogin
set connLogin = Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & Server.MapPath("\test\Login.mdb") & ";"
connLogin.Open(sConnString)
MySQL = "SELECT * FROM Users WHERE Username = '" + Replace(rsLogin__prmUsername, "'", "''") + "' AND Password = '" + Replace(rsLogin__prmPassword, "'", "''") + "'"
set rsLogin = connLogin.Execute(MySQL)
the vars placed in the replace funtions are delared earlier and i can seem to get to know how to define a DSN on my 'virtual server' PLEASE HELP!
my server provide say i've got MySQL on my server (is that nay help?)
" |
|
|
|
|
|
DSN less connections