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.
Problem Adding System DSN for SQL Server
Question:
I'm simply trying to add an odbc connection for SQL Server.. always returing 0 (failed) OS=XP
WB=2003G
;CODE
addExtender("wwodb34i.dll")
request=4
driver="SQL Server"
attrs="DSN=ClientCalls|Description=Client Calls Database|Driver=c:\windows\system32\sqlsrv32.dll|LastUser=sa|Server=smarttest";pipe delimited
displayflag=@TRUE
ret=qConfigData(4,driver, attrs, @TRUE)
If ret==0 then
Message("","Failed")
test = qConfigError()
message("",test)
else
Message("","Successful")
endif
Any suggestions??
Answer:
Note: qConfigError( ) returns error or status information if qConfigData fails...Try:
AddExtender("wwodb34i.dll")
request=4
driver="SQL Server"
attrs="DSN=ClientCalls|Description=Client Calls Database|Driver=c:\windows\system32\sqlsrv32.dll|LastUser=sa|Server=smarttest";pipe delimited
ret = qConfigData(request, driver, attrs, 0) ;line will error
if ret==0
AskItemList("DSN Configuration failed", qConfigError(),@TAB,@UNSORTED,@SINGLE)
exit
endif
message("qConfigData", "Successfull")
User reply:
..Getting;"Invalid Keyword Value Pairs" "Driver's ConfigDSN,ConfigDriver, or ConfigTranslator failed"I looked on another PC with this ODBC, checked the registry for odbc.ini, and added those keys to the attrs.
Am I missing something else?
Answer:
It doesn't seem to like the attributes your specifying.attrs="DSN=ClientCalls|Description=Client Calls Database|Driver=c:\windows\system32\sqlsrv32.dll|LastUser=sa|Server=smarttest";pipe delimited
Here is some code the has worked in the past.
:createDSN
addextender("wwodb34i.dll")
;Create DSN
request=4;ADD SYSTEM DSN
driver="SQL Server";case sensitive
attrs="DSN=SecurityRpt|DESCRIPTION=Security ALRS Reporting|SERVER=Server|Trusted_Connection=Yes";pipe delimited
displayflag=@false
ret=qConfigData(request, driver, attrs, displayflag)
if ret== @false
message("qConfigData failed", qConfigError())
exit
endif
return
Article ID: W15846
File Created: 2014:07:18:09:49:32
Last Updated: 2014:07:18:09:49:32