I have done everything by the book here.
I have installed the Visual FoxPro ODBC driver since it isnt included
with mdac 2.8
I have cfmx 6.1 on my devbox
I have created the dsn in system dsn in odbc panel
I have created the odbc socket in cfadmin
I have specified the EXACT same information to another devbox, same
everything in my house...one works, one doesn't. and I don't know where
to turn.
about the question I asked, someone from the list had mentioned to me
off list that it looked like the jdbc driver was controlling the data
connection, and that CFMX and VFP must use odbc to talk to each other.
since his email and my message to the list was sent, I kinda determined
that that wasn't EXACTLY true, and don't really know what he meant.
anyway, its really strange and annoying
here is the error again:
Connection verification failed for data source: debtNet
[]java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink
Server]The specified data source is not defined.
The root cause was that: java.sql.SQLException: [Macromedia][SequeLink
JDBC Driver][SequeLink Server]The specified data source is not defined.
....tony
r e v o l u t i o n w e b d e s i g n
[EMAIL PROTECTED]
www.revolutionwebdesign.com
its only looks good to those who can see bad as well
-anonymous
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 28, 2004 12:10 AM
To: CF-Talk
Subject: RE: jdbc vs odbc with Visual FoxPro
> how can I specify to my cfmx server that I want to use an
> odbc driver vs. a jdbc driver when connecting to a Visual
> FoxPro odbc dsn?
I'm not sure I understand exactly what you're asking. Unless you have a
specific JDBC driver for VFP, you'll have to create an ODBC data source,
then use the ODBC Socket selection within the CF Administrator.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
