Lists: | pgsql-odbc |
---|
From: | "Joseph Watson" <jtwatson(at)datakota(dot)com> |
---|---|
To: | <pgsql-ODBC(at)postgresql(dot)org> |
Subject: | Connection Problem |
Date: | 2002-01-24 03:08:27 |
Message-ID: | 001901c1a484$6fd8c4c0$0a01a8c0@bay.chartermi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Hello,
I am having a problem connecting to postgresql using Access and ODBCDirect. I am not sure that the problem is a odbc related problem, but I figured that I would ask and see if I could get a answer. I am using Access 2000, PostreSQL 7.1.2 and pgsql-ODBC V 7.01.00.09. When using any other method of connection (linked tables, pass-through query's) all seems to work great. But when I try to use ODBCDirect I get a Type mismatch error from Access. Here is the connection code.
Private Sub cmdLogon_Click()
Dim FSEInfo As Workspace
Dim cnn As Connection
Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser, txtPassword, dbUseODBC)
Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn", dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
cnn.Close
Exit Sub
End Sub
The txtUser and txtPassword is supplyed by the user through a form. Also here is the log output from the linux box running PostgreSQL.
2002-01-23 10:06:33 DEBUG: connection: host=192.168.1.10 user=jtwatson database=fseinfo
2002-01-23 10:06:33 DEBUG: query: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: query: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: query: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: query: select oid from pg_type where typname='lo'
2002-01-23 10:06:33 DEBUG: query: select version()
It looks to me like the connection was excepted and successfull, but I get a Type mismatch error # 13. Can anyone help me out here. Any feedback would be appreciated.
Joseph
From: | "Gerrit Kilian" <g(dot)kilian(at)anderson(dot)co(dot)za> |
---|---|
To: | "pgsql-ODBC \(E-mail\)" <pgsql-ODBC(at)postgresql(dot)org> |
Subject: | Re: Connection Problem |
Date: | 2002-01-24 06:49:51 |
Message-ID: | 000201c1a4a3$5430e6c0$320102c8@ANDERSON |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Hi
I was just wondering if ADO with the OLE DB provider for ODBC not a better
choice is to connect to Postgresql? ODBCDirect is really just RDO ( Remote
Data Objects ) using DAO object names. Do you experience better performance
with ODBCDirect than ADO?
Kind Regards
Gerrit
-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Joseph Watson
Sent: Thursday, January 24, 2002 5:08 AM
To: pgsql-ODBC(at)postgresql(dot)org
Subject: [ODBC] Connection Problem
Hello,
I am having a problem connecting to postgresql using Access and
ODBCDirect. I am not sure that the problem is a odbc related problem, but I
figured that I would ask and see if I could get a answer. I am using Access
2000, PostreSQL 7.1.2 and pgsql-ODBC V 7.01.00.09. When using any other
method of connection (linked tables, pass-through query's) all seems to work
great. But when I try to use ODBCDirect I get a Type mismatch error from
Access. Here is the connection code.
Private Sub cmdLogon_Click()
Dim FSEInfo As Workspace
Dim cnn As Connection
Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser, txtPassword,
dbUseODBC)
Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn",
dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
cnn.Close
Exit Sub
End Sub
The txtUser and txtPassword is supplyed by the user through a form. Also
here is the log output from the linux box running PostgreSQL.
2002-01-23 10:06:33 DEBUG: connection: host=192.168.1.10 user=jtwatson
database=fseinfo
2002-01-23 10:06:33 DEBUG: query: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set DateStyle to 'ISO'
2002-01-23 10:06:33 DEBUG: query: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set geqo to 'OFF'
2002-01-23 10:06:33 DEBUG: query: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: ProcessUtility: set ksqo to 'ON'
2002-01-23 10:06:33 DEBUG: query: select oid from pg_type where
typname='lo'
2002-01-23 10:06:33 DEBUG: query: select version()
It looks to me like the connection was excepted and successfull, but I get
a Type mismatch error # 13. Can anyone help me out here. Any feedback
would be appreciated.
Joseph
From: | Joseph Watson <jtwatson(at)datakota(dot)com> |
---|---|
To: | Gerrit Kilian <g(dot)kilian(at)anderson(dot)co(dot)za> |
Cc: | "pgsql-ODBC (E-mail)" <pgsql-ODBC(at)postgresql(dot)org> |
Subject: | Re: Connection Problem |
Date: | 2002-01-24 23:03:15 |
Message-ID: | 3C5092B3.5080304@datakota.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Well to be honest, I don't know. I need to be able to start a transation,
make query's, and then based on the results, I need to decide if I can make
the changes to the database, then commit or rollback. This was not working
with passthrough queiryes, but most likley I just don't know enouph, and
was doing it wrong. So I am trying ODBCDirect. Also I want my database to
be client independent as much as possible, so if I can bypass Jet, I would
like to.
Joseph
Gerrit Kilian wrote:
> Hi
>
> I was just wondering if ADO with the OLE DB provider for ODBC not a
> better choice is to connect to Postgresql? ODBCDirect is really just RDO
> ( Remote Data Objects ) using DAO object names. Do you experience better
> performance with ODBCDirect than ADO?
>
> Kind Regards
> Gerrit
>
>
>
>
>
> -----Original Message-----
> *From:* pgsql-odbc-owner(at)postgresql(dot)org
> [mailto:pgsql-odbc-owner(at)postgresql(dot)org]*On Behalf Of* Joseph Watson
> *Sent:* Thursday, January 24, 2002 5:08 AM
> *To:* pgsql-ODBC(at)postgresql(dot)org
> *Subject:* [ODBC] Connection Problem
>
> Hello,
>
>
>
> I am having a problem connecting to postgresql using Access and
> ODBCDirect. I am not sure that the problem is a odbc related
> problem, but I figured that I would ask and see if I could get a
> answer. I am using Access 2000, PostreSQL 7.1.2 and pgsql-ODBC V
> 7.01.00.09. When using any other method of connection (linked
> tables, pass-through query's) all seems to work great. But when I
> try to use ODBCDirect I get a Type mismatch error from Access. Here
> is the connection code.
>
>
>
> Private Sub cmdLogon_Click()
>
> Dim FSEInfo As Workspace
> Dim cnn As Connection
>
> Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser,
> txtPassword, dbUseODBC)
>
>
>
> Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn",
> dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
>
> cnn.Close
>
> Exit Sub
>
>
>
> End Sub
>
>
>
> The txtUser and txtPassword is supplyed by the user through a form.
> Also here is the log output from the linux box running PostgreSQL.
>
>
>
> 2002-01-23 10:06:33 DEBUG: connection: host=192.168.1.10
> user=jtwatson database=fseinfo
> 2002-01-23 10:06:33 DEBUG: query: set DateStyle to 'ISO'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set DateStyle to 'ISO'
> 2002-01-23 10:06:33 DEBUG: query: set geqo to 'OFF'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set geqo to 'OFF'
> 2002-01-23 10:06:33 DEBUG: query: set ksqo to 'ON'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set ksqo to 'ON'
> 2002-01-23 10:06:33 DEBUG: query: select oid from pg_type where
> typname='lo'
> 2002-01-23 10:06:33 DEBUG: query: select version()
>
>
>
> It looks to me like the connection was excepted and successfull, but
> I get a Type mismatch error # 13. Can anyone help me out here. Any
> feedback would be appreciated.
>
>
>
>
>
> Joseph
>
>
>
From: | "Joseph Watson" <jtwatson(at)datakota(dot)com> |
---|---|
To: | "pgsql-ODBC \(E-mail\)" <pgsql-ODBC(at)postgresql(dot)org> |
Subject: | ODBCDirect |
Date: | 2002-01-25 01:18:37 |
Message-ID: | 001401c1a53e$37a06b20$0a01a8c0@bay.chartermi.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
Hello,
Has anyone used MS ODBCDirect with pgsql-ODBC V 7.01.00.09 and PostreSQL 7.1.2 successfully? I am wondering if there may be a conflict between the odbc driver and ODBCDirect?? I can make linked tables, or pass-through query's work just fine, but not ODBCDirect. I get a Type mismatch error. So if anyone has make this work, please let me know so that I can narrow things down a little. Thanks for any help!
Joseph
From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Joseph Watson <jtwatson(at)datakota(dot)com> |
Cc: | pgsql-ODBC(at)postgresql(dot)org |
Subject: | Re: Connection Problem |
Date: | 2002-01-25 03:07:43 |
Message-ID: | 3C50CBFF.AA22AFF8@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-odbc |
> Joseph Watson wrote:
>
> Hello,
>
> I am having a problem connecting to postgresql using Access and
> ODBCDirect. I am not sure that the problem is a odbc related problem,
> but I figured that I would ask and see if I could get a answer. I am
> using Access 2000, PostreSQL 7.1.2 and pgsql-ODBC V 7.01.00.09. When
> using any other method of connection (linked tables, pass-through
> query's) all seems to work great. But when I try to use ODBCDirect I
> get a Type mismatch error from Access. Here is the connection code.
>
> Private Sub cmdLogon_Click()
> Dim FSEInfo As Workspace
> Dim cnn As Connection
>
> Set FSEInfo = CreateWorkspace("FSE_Info_ws", txtUser, txtPassword,
> dbUseODBC)
>
> Set cnn = FSEInfo.OpenConnection("FSE_Info_cnn",
> dbDriverCompleteRequired, False, "ODBC;DSN=FSE Info;")
>
> cnn.Close
>
> Exit Sub
>
> End Sub
>
> The txtUser and txtPassword is supplyed by the user through a form.
> Also here is the log output from the linux box running PostgreSQL.
>
> 2002-01-23 10:06:33 DEBUG: connection: host=192.168.1.10
> user=jtwatson database=fseinfo
> 2002-01-23 10:06:33 DEBUG: query: set DateStyle to 'ISO'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set DateStyle to 'ISO'
> 2002-01-23 10:06:33 DEBUG: query: set geqo to 'OFF'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set geqo to 'OFF'
> 2002-01-23 10:06:33 DEBUG: query: set ksqo to 'ON'
> 2002-01-23 10:06:33 DEBUG: ProcessUtility: set ksqo to 'ON'
> 2002-01-23 10:06:33 DEBUG: query: select oid from pg_type where
> typname='lo'
> 2002-01-23 10:06:33 DEBUG: query: select version()
>
> It looks to me like the connection was excepted and successfull, but I
> get a Type mismatch error # 13. Can anyone help me out here. Any
> feedback would be appreciated.
Can you send me the Mylog debug output ?
You can turn on the Mylog option using ODBC Datasource
administraotr.
regards,
Hiroshi Inoue