Re: [Tcl-tdbc] ODBC connection errors

[Patrick D. <pat...@ac...>]

Yes, you caught me. I did source tdbcodbc.tcl. package require wasn't
working I assumed because of the install problems so I decided to source to
get around that. This will probably all be resolved when I get a clean
install performed. 

Patrick Dunnigan

Email: pat...@ac...

Visit us at www.activecompliance.com

This e-mail message is intended only for the use of the individual or entity
to which it is addressed, and may contain information that is confidential.
If you are not the intended recipient, any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify us immediately by reply email.

-----Original Message-----
From: Kevin Kenny [mailto:kk...@ny...] 
Sent: Tuesday, February 10, 2009 10:04 PM
To: pat...@ac...
Cc: tcl...@li...
Subject: Re: [Tcl-tdbc] ODBC connection errors

Patrick Dunnigan wrote:
> I have  tdbc odbc loaded, but I am sill trying to work out the exact 
> connection syntax. I am expecting to pass the DSN-less connection string 
> but getting an error as you can see below:
> 
> % set conn_string "DRIVER=SQL 
> Server;SERVER=192.168.2.105,1433;DBQ=test;UID=test;PWD=test "
> 
> DRIVER=SQL Server;SERVER=192.168.2.105,1433;DBQ=test;UID=test;PWD=test
> 
> % tdbc::odbc::connection create db $conn_string
> 
> unknown method "init": must be allrows, close, columns, destroy, eval, 
> foreach,prepare, preparecall, resultsets, statements, tables, 
> transaction, typemap, unknown, variable or varnamePatrick Dunnigan
> 
> I know this is the correct connection string, I have tested it out with 
> other software. I am thinking that I am not using the 
> tdbc::odbc::connection command the right way for ODBC connections.

Did you do [package require tdbc::odbc], or did you just do
[source tdbcodbc.tcl]? You appear to be missing the parts of the
driver that are written in C.  I know that you had installation
problems, so it's possible that your [package require] went
awry.

By the way, your connection string and your syntax both look quite
plausible.

-- 
73 de ke9tv/2, Kevin