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 |
|
red3recon
Starting Member
5 Posts |
 Posted - 2009-01-02 : 11:18:55
|
| When I used the below code on SQL2000 it worked fine. When I upgraded my DB to 2005 it started listing everything twice! I changed the provider= in the connection string from SQLOLEDB.1 to SQLNCLI with no love either way. The code is in a form used to create a list of records, the user selects the record, clicks the submit button and opens the record. The page still works, but everything is listed twice. I am using hand-jammed ASP with VB.Code snippet:Set objDB = Server.CreateObject("ADODB.Connection")objDB.Open sDBName, sDBUser, sDBpwdSet objRS = Server.CreateObject("ADODB.Recordset") set objrs = objdb.execute("select * from dbo.MyTable order by Item") do while not objrs.eof response.write("<option value='" & objrs("Record") & "'") response.write(">" & objrs("Record") & "</option>" & vbCrLf) objrs.movenext loop objrs.close objdb.close set objrs = nothing set objdb = nothingAny help or insight is greatly appreciated!I have an image but no place to host it |
|
|
|
|
|
Possible connection error? ASP --> SQL2000/2005