debug ADO error 1

achai · Aug 8, 2000

error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e4e' Operation Canceled" ---------------------------- code: <%      Set oConn = Server.CreateObject("ADODB.Connection&quot

Set oRs = Server.CreateObject("ADODB.Recordset&quot

oConn.Open "driver=Microsoft Access Driver (*.mdb);SERVER=PWS;database=quickstore;USERID=;PASSWORD=;"       strSQL = "SELECT * FROM customers order BY customerID"       Set oRs = oConn.Execute(strSQL)       Do While Not oRs.EOF          Response.Write "<OPTION>" & oRs.Fields("firstname&quot

& "</OPTION>" & vbcrlf          oRs.MoveNext       Loop       Set oRs = Nothing       Set oConn = Nothing    %> ---------------------------- explain: I use PWS, i use ODBC data source administrator to connect datasource. error seems i don't have ADO.

palbano · Aug 8, 2000

> i use ODBC data source administrator to connect datasource. If that is true then your connection.Open call should look somthing like this: oConn.Open "DSN=MyDsn;" Good luck -pete

achai · Aug 8, 2000

i change to --------- oConn.Open "dsn=quickstore;driver=Microsoft Access Driver (*.mdb);SERVER=PWS;database=quickstore;USERID=;PASSWORD=;" It works. thanks. can you explain why?

palbano · Aug 8, 2000

> can you explain why? Because that is the purpose of the DSN entry in the ODBC Manager, to provide the connection information. Actually it should work just as I posted it: oConn.Open "dsn=quickstore;" if your DSN entry is setup correctly. -pete

achai · Aug 9, 2000

thank for explaination. but why others use oConn.Open "driver=bla,bla;SERVER=bla;database=bla;USERID=;PASSWORD=;" to connect the database? they don't use ODBC manager?

NickBulka · Aug 9, 2000

the method you desribe in your last post is generally used for OLEDB access, not ODBC. nick bulka <a href=mailto: > </a> <a href= > </a>

jfriestman · Aug 9, 2000

A quick rundown of three ways to connect to a database 1.  ODBC Manager Enter all configuration information through the ODBC manager and the ODBC driver.  Connect to your database like this: "DSN=Northwind;" 2. DSN-less ODBC connection Script the same information, connect with the ODBC driver but don't need to set up a system level DSN. SQL Server connection string looks like this: "Driver={SQL Server}; Server=(local); Database=Northwind; UID=sa; PWD=;" Access connection string looks like this: "Driver={Microsoft Access Driver (*.mdb)}; DBQ=C:\Temp\Northwind.mdb" 3. DSN-less OLEDB connection Script similar information but use the OLEDB native driver. SQL Server Connection string looks like this: "Provider=SQLOLEDB; Data_Source=(local); Initial Catalog=Northwind; User Id=sa; Password=;" Access connection string looks like this; "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp\Northwind.mdb" --------------------- So what are the differences?  Well, it helps if you understand how ODBC is used.  ODBC is a vendor independent layer between your applications and the databases.  OLEDB is a Microsoft specific layer between your application and the database.  When ADO connects to your database through ODBC, it actually goes ADO -> ODBC -> OLEDB -> Database. So what does all this mean? 1. Using a DSN-less OLEDB connection is going to give you faster access because you don't have to go through the ODBC driver.  (ADO -> OLEDB -> Database) 2. If your ISP charges you to set up a DSN, using a DSN-less connection will save you a few bucks. 3. Moving applications between machines is a breeze with a DSN-less connection because you don't have to remember to set up ODBC DSNs on multiple systems. 4. A DSN-less connection is potentially less secure because your DB password is scripted in your page.  If someone has access to your ASP source code, they have access to your database password. That't the gist of it.  Hope this helps. Jeff Friestman <a href=mailto: > </a> <a href=

http://www.brainbench.com/transcript.jsp?pid=61192>

View my Brainbench transcript</a> Brainbench 'Most Valuable Professional' for ASP 
Brainbench 'Most Valuable Professional' for JavaScript

http://www.brainbench.com

achai · Aug 9, 2000

i use ODBC administrator to connect informix database. --------- error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [MERANT][ODBC Informix driver]Insufficient information to connect to the data source. --------- code: <% set oconn=server.createobject("adodb.connection&quot

set oRs = Server.CreateObject("ADODB.Recordset&quot

oConn.Open "dsn=informix;driver={MERANT 3.60 32-BIT INFORMIX};server=DEV0_TCP;database=informix;" strSQL = "SELECT * FROM user_type" .............

jfriestman · Aug 9, 2000

Your connection string looks like a witches brew of parameters. 1. Where's your username and password in the connection string? 2. Why are you putting the driver and the DSN in the same connection string?  If you've already set up DSN, you shouldn't need to also specify a driver. 3. You connection string:database=Informix?  Are you sure?  Your RDBMS is informix but your database probably isn't named informix. I don't think there is a native OLEDB driver for informix so look at my previous post and set up your DSN-less connection using the ODBC syntax I describe. Jeff Friestman <a href=mailto: > </a> <a href=

http://www.brainbench.com/transcript.jsp?pid=61192>

View my Brainbench transcript</a> Brainbench 'Most Valuable Professional' for ASP 
Brainbench 'Most Valuable Professional' for JavaScript

http://www.brainbench.com

achai · Aug 9, 2000

I changed oConn.Open "dsn=informix;driver={MERANT 3.60 32-BIT INFORMIX};server=DEV0_TCP;database=informix;" to oConn.Open "dsn=informix;" now it works very well. thanks. I didn't notice the explaination you wrote ealier. it exactly answers my question.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

debug ADO error 1

achai

MIS

palbano

Programmer

achai

MIS

palbano

Programmer

achai

MIS

NickBulka

Programmer

jfriestman

Programmer

achai

MIS

jfriestman

Programmer

achai

MIS

Similar threads

Part and Inventory Search

Sponsor