Hi Dr. Thomas,
Found this behavior: I'm connecting to sap from Visual Foxpro 7 SP1,
when
creating a new connection with 7.4 ODBC driver and entering manually
the
driver,username & password and database in the connection designer
dialog
window I got this message from the ODBC:
"Connectivity error: [SAP AG][SQLOD32.DLL][SAP DB] unable to connect
data
source; -709 connect: (Database not running)"
But if make the connection with a connection string then it works
fine:
"DSN=asapd;UID=FOO;PWD=FOO;SERVERDB=tmu;SERVERNODE=192.168.0.109;DRIV
ER=;"
Also there was no log written o both files C:\SQL.LOG nor
C:\WINNT\sqltrace.pct.
After that I run a small program to upload data to SAPDB from VB,
this is
the code:
Set fso = CreateObject("Scripting.FileSystemObject")
Set MC = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
wODBC = "ODBC;DATABASE=TMU;UID=foo;PWD=foo;DSN=asapd"
MC.Open (wODBC)
In the last line I got the same error of connectivity error
described above,
but a log was written to C:\SQL.LOG and C:\WINNT\sqltrace.pct, this
is the
content for sqltrace.pct:
<html><head><meta http-equiv="Content-Type" content="text/html;
charset=utf-8"></head><body ><PRE><PLAINTEXT>
PRODUCT : SAP DB C-PreComp Runtime
VERSION : 7.4.3
BUILD : 009-111-000-000
DATASOURCE: asapd
SESSION : 0;
SQLMODE : INTERN
SERVERDB : TMU
SERVERNODE:
CONNECT "FOO " IDENTIFIED BY :A ISOLATION LEVEL 1
SQLCODE: -709 CONNECT: (database not running)
START : DATE : 2003-03-24 TIME : 0008:48:39
END : DATE : 2003-03-24 TIME : 0008:48:39
SQCFINISH
SQL.LOG is 479Kb size, could send it to a private email if you want.
Thanks in advance.
--
Josu� Maldonado
"Koetter, Thomas Theodor" <[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> Hi Joseu,
>
> > -----Original Message-----
> > From: Josu� Maldonado [mailto:[EMAIL PROTECTED]
> > Sent: Freitag, 21. M�rz 2003 23:20
> > To: [EMAIL PROTECTED]
> > Subject: ODBC 7.4 not working
> >
> >
> > Hi list,
> >
> > Database server is 7.4 running on RH 7.3, I just installed
> > ODBC drivers 7.4
> > and can't connect to the DB, message error said DB is not
> > running. But ODBC
> > 7.3 works fine.
>
> Please provide me with a driver trace and accurate information
> what happened (including error texts).
> http://sapdb.2scale.net/moin.cgi/ODBCTrace
>
> > Does the 7.4 ODBC driver is still in beta? should I keep
> > using ODBC 7.3
> > instead?. Any other idea or comment is welcome.
>
> ODBC 7.4 is not regarded as beta. The main difference between
> ODBC 7.4 and 7.3.0 is the ODBC-Unicode-API (SQLConnectW etc).
> If you don't need this API, you may be well served by 7.3.0,
> that is maintained as well as 7.4.
>
>
> Regards Thomas
>
>
> ----------------------------------------------
> Dr. Thomas K�tter
> SAP DB, SAP Labs Berlin
>
>
> SAP DB is open source. Get it! www.sapdb.org
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
