|
Jeremy,
I have
had ASP talking to IB before - nothing has changed much since, so I'll try and
get it going tommorow (when I remember to bring in my Win2K
cd).
As for
TCP vrs local - a local connection is using shared memory, and NT's security
gets in the way, 'cos it doesn't like sharing memory, and NT doesn't have "nice"
SHM functions, so you have to use IP, which basically loops thru the IP stack,
but gets around the security problem - there is only a trivial amount of
difference (ie, it should be slower, logically. I've never noticed that it
is)
N
--
Nic Wise - [EMAIL PROTECTED] / Inprise/Borland New
Zealand
main line: 09.360.0231 / ddi: 09.360.6713 / cell:
021.676.418
Added to this, I just went to ODBC connection I made,
and tried the TEST CONNECTION button.
If I
use TCP/IP it cant connect. If I use <local> it can connect
!
I
have also confiremd this with the Interbase Communications diagnostic
tool.
Another thought I had is that the IB Server is
actually local to my machine, not on another machine.
If I
am using TCP/IP, it would be doing a Remote Server connection.....would this
be a problem ??
Cheers, Jeremy Coulter
Did you make sure that your data source is
using a TCPIP connection instead of a local connection?
Richard
----- Original Message -----
Sent: Saturday, July 29, 2000 12:19
PM
Subject: [DUG]: Interbase access from
ASP Pages
Hi
all.
I am wanting
to connect to an Interbase DB via an ASP page, using an
ADODB.Connection.
I found some
info on creating an ODBC connection to Interbase on the Interbase website,
BUT when the code in the ASP Page trys to open the ODBC connection, it
says :-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
It only seems to be
Interbase I have this problem with. I can connect to MSSQL DB's
fine.
Has anyone succesfully done
whatI am wanting to do before, AND got it to work ?
Am
I simply missing something obvious ??
Cheers,
Jeremy Coulter (manager)
Visual
Software Solutions
145
Langdons Road
Christchurch
ph +64 3
3521595
fx +64 3 3521596
cell +21 2533214
http://www.vss.co.nz
|
