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
