Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ODBC
 |
- !!NEWSFLASH!!
- 1437 or 3437 Extender Load Error
- 3132 error when using DAO
- 521 Attribute string too long
- Access SQL Update
- An SQL Tutorial
- Automated ODBC Data Source creation
- Calling a MS SQL Server 2000 Stored Procedure
- Change database then Update then count rows
- Compact an Access Database
- COMPACT_DB and Password MDB Files
- Continue a SQL Query after a Warning Message from Driver
- Create a System DSN for a TXT File Problem
- Create an SQL DSN with User name and Password
- DSN Connection Strings
- Execute an Oracle stored procedure
- Explanation of ODBC Usage
- Get Installed Driver Information
- Get Parameters from a Stored Procedure
- How Does qBindCol Work
- How to Do a Simple Sql Query
- Invalid Cursor State Error
- MDAC Invalid Object
- Microsoft SQL Server ODBC driver Info
- More on How ODBC Works
- ODBC and Services
- ODBC and SQL
- ODBC DSN Maker
- ODBC DSN Port Configuration
- ODBC Extender with WebBatch problems
- ODBC on 64 bit System
- ODBC SQLDescribeCol Example
- ODBC WHERE Syntax Blank Data
- Pervasive SQL Syntax Error
- Problem Adding System DSN for SQL Server
- Problem Using qConfigData with the Oracle ODBC Driver
- qConnect Crashes with Exit Code -1073741571
- qExecDirect and SQL Questions
- QExecDirect Second handle issue with SQL Server Drivers
- qFetch with Empty Cell
- qFetch with qBindCol and qGetData
- qGetData 50 columns limit
- qLastCode to Check these SQL Return Codes
- Read Information from Lotus Notes
- Retrieving data after a SQL JOIN
- Return Codes in ODBC Extender
- s0022 error from SQL Server Driver
- Specify SQL Server Password in qConfigData
- SQL Server SELECT SUM Statement
- SQL SUCCESS WITH INFO
- Syntax for Insert Into Access
- Updating ODBC.INI File over the Network
- Using WildCards in an ODBC SQL Statement
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: 3132 error when using DAO
Question:
I get error 3132 'OLE has not been initialised (or string is missing its quotes)' at the the line...
ws = dao.CreateWorkspace("JetWorkspace", "admin", "")
This error only happens with the compiled code - it works fine from the interpreter (within WinBatch Studio).
I assume I've left something out but can't track it down. Any help would be appreciated.
Sample code
dao = objectopen("DAO.DBEngine.35")
ws = dao.CreateWorkspace("JetWorkspace", "admin", "")
db = ws.OpenDatabase("%WorkDir%ServData.mdb")
sqlstr = "SELECT * FROM SERVER ;"
rs = db.openrecordset(sqlstr)
SServer = rs.fields("Servername")
rs.ADDNEW
SServer.value = "%ThisServ%"
rs.UPDATE
ObjectClose(rs)
ObjectClose(db)
ObjectClose(ws)
ObjectClose(dao)
Answer:
- Just a thought.... because a similar thing occured with me between the
command line and compiled version:
rather than call the DBEngine directly
oAPP = OpenObject("Access Application.8") DB = oAPP.DBEnginethen create your workspace.
- Another possiblity: Compiler and Interpreter are not the same version number. Possibly using a newer
interpreter and an older compiler. Make sure they're the same version by adding ver=Version()
to the top of your code and display it in a message box (run it both uncompiled and compiled).
- And another possiblity: Compiler code running on a different environment, causing problems. For testing....Put the compiled exe in your WinBatch\System directory and test from there as a logged on user (not a service job or anything). See if it works. If it works, then possibly there is a broken or out-of-date file in your test area, most likely WBO??34I.DLL (If you are using WB2001).
Article ID: W14425
Filename: 3132 error when using DAO.txt
File Created: 2017:07:28:13:58:31
Last Updated: 2001:12:12:17:16:30