Re: [Firebird-odbc-devel] [Microsoft][ODBC Driver Manager] Data source name too long - inserting rows

[Jano P. <jan...@gm...>]

John,


If I understand correctly, your application can read the data from tables
with no issues whatsoever, but when you try to insert rows into tables it
fails? hat about the UPDATE or DELETE?


I have found some references to the message you are getting on the net, most
common explanation is:

Your connection string is malformed (perhaps you mixed up the Provider and
Driver keywords?).


Have you tried linking the FireBird database to MS Access and modifying
tables there through UI or queries and see if that works? If it does, get a
copy of connection string used there.

Have you tried without localhost: bit in the data source name (just for the
sake of troubleshooting)?

Is this an ASP application or standard winapp?


Regards
Jano



On 12/08/07, John Sails <joh...@ho...> wrote:
>
>  Can you post this?:
> I get this error trying to do insert rows
> into firbird XP Pro SP2
> I can only read tables. Write permissions set  on folder holding FDB.
>
> Firebird_ODBC_2.0.0-Win32 installed:
>   DRIVER=Firebird/InterBase(r)
> driver;ServerType=1;User=SYSDBA;Password=masterkey;Database=localhost:C:\FireBirdDB\PLUM.FDB;
>
> ------------------------------
> Insert into P2_TBL (P_ID,P_IMPORT_ID,P_FIRST_NAME,P_LAST_NAME) values
> (3,'10003','John','test24'); Microsoft OLE DB Provider for ODBC Drivers error
> '80004005'
>
> [Microsoft][ODBC Driver Manager] Data source name too long
>
> HELP!
> Thanks
> john
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >>  http://get.splunk.com/
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
>
>