PC Review


Reply
Thread Tools Rate Thread

ODBC driver does not support the requested properties

 
 
=?Utf-8?B?TWFyYyBPbGl2aWVyIEdveWV0dGU=?=
Guest
Posts: n/a
 
      8th Apr 2004
Hi

I built a code that executes an SQL code over an ODCB connection. My problem is that this code is working well on my computer but isn't working on 6 others similar(should be exactly the same computer but it is not since I got this problem...) computer that I tried my code

The same driver is installed on all machines (Client Access ODBC Driver (32-bit) v 7.00.00.00). And on my machine eiter I set the source database or not won't change anything since it is hard code

Also, I am able to connect on the AS400 table, the problem is to retrieve the data. The regional setting is the same on every computer

Error message at the line : -2147217887-ODBC driver does not support the requested propertie

Sub TestDataSourceUsingADO(
Dim conn As Objec
Dim rcset As Objec
Dim connstr As Strin
Dim sqlstr As Strin

Dim userID As Strin
Dim pwd As Strin

userID = "username"
pwd = "password"

On Error GoTo errHandle
Set conn = CreateObject("ADODB.Connection"
connstr = "DRIVER={Client Access ODBC Driver (32-bit)};SYSTEM=10.10.16.91;DBQ=AS400

conn.Open connstr, userID, pw

Set rcset = CreateObject("ADODB.Recordset"
sqlstr = "SELECT * FROM CANADA.KB4400CSTM.FCMSFC54C FCMSFC54C

rcset.Open sqlstr, conn, 1,

If Not rcset.EOF The
MsgBox rcset.Fields(0).Name & "-" & rcset.Fields(0).Valu
End I

exitSub
rcset.Close: Set rcset = Nothin
conn.Close: Set conn = Nothin
Msgbox "Your data connection is working.",vbokonly+vbinformation,"Info
errHandler
MsgBox Err.Number & "-" & Err.Description, vbOKOnly + vbExclamation, "Error
End Su

Thanks For your Hel

Marc
 
Reply With Quote
 
 
 
 
kkknie
Guest
Posts: n/a
 
      8th Apr 2004
Could it be different versions of ADO? I've tried to with a referenc
to ADO 2.6 on an older box and it didn't work. Had to go all the wa
back to 2.1.

Another question, do you get the error on the conn.Open method or th
rcset.Open method?



--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWFyYyBPbGl2aWVyIEdveWV0dGU=?=
Guest
Posts: n/a
 
      8th Apr 2004
K

I got the error at the rcset.open line

How do I uninstall the ADO that I have ? I'm not sure I understand everyting about ADO. I have update all the MDAC 2.8 on all PC to be sure that this wasn't the problem

Thanks for your inpu

Marc
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). sudhaoncyberworld@gmail.com Microsoft Dot NET 0 16th Jul 2007 12:30 PM
The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). sudhaoncyberworld@gmail.com Microsoft Dot NET 0 16th Jul 2007 07:27 AM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 0 30th Mar 2006 04:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 1 24th Mar 2006 05:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer Microsoft ASP .NET 0 24th Mar 2006 03:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:11 PM.