[Firebird-odbc-devel] Insert errors in IIS classic ASP

[John S. <joh...@ho...>]

Thanks  for the comments but:
Still can't Insert row, But can read firebird DB tables.
(classic ASP, IIS 5.1 XP pro sp2)
IWAM and IUSER set with write permissions.
=20
Are there any settings in IIS that might stop writing to FireBird?
The web ASP application is working ok with MS SQL and MS Access.
But we are trying to convert to firebird and interface with a Firebird appl=
ication.....
=20
conn string:
Provider=3DMSDASQL.1;Persist Security Info=3DFalse; DRIVER=3DFirebird/Inter=
Base(r) driver;ServerType=3D1;User=3DSYSDBA;Password=3Dmasterkey;Database=
=3DC:\FireBirdDB\FASTPASS4.FDB;
(tried various versions)
ERRORS when trying to insert a row.:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20
[Microsoft][ODBC Driver Manager] Data source name too long=20
=20
the nsert syntax was verified in th IBOConsol.
 Thanks for any ideas...
john


Date: Mon, 13 Aug 2007 13:38:56 +1000From: jan...@gm...To: firebir=
d-o...@li...Subject: Re: [Firebird-odbc-devel] [Micro=
soft][ODBC Driver Manager] Data source name too long - inserting rowJohn,Ha=
ve you tried adding provider bit (this is important for OLE DB access)? Exa=
mple connection string:Provider=3DMSDASQL.1;Password=3Dmasterkey;Persist Se=
curity Info=3DTrue;User ID=3DSYSDBA;Extended Properties=3D"DRIVER=3DFirebir=
d/InterBase(r) driver;Database=3DC:\temp\TEST.FDB" RegardsJano =