Thanks, no luck tho...
Here's the code:
if($_SESSION["VIEW"] == "private")
if (($odbc_conn = odbc_connect("D3_ACTIVE","","")) === false)
die("ODBC connect call failed");
and the result:
Warning: odbc_connect(): SQL error: [Raining Data][ODBC D3 Driver]Logon
failed. Check D3 connection parameters and available licenses., SQL state
28000 in SQLConnect in C:\Documents and Settings\Administrator\My
Documents\www\activetest\searchresults.php on line 118
ODBC connect call failed
I don't want to patch the php source code if I don't have to. It's running
on IIS - I thought of writing a vb script to do the odbc query and return
the result to php i.e. using http calls from inside the php script... If I
try it I'll let you know if it works.
Greg
"Bastien Koert" <bastien_k@xxxxxxxxxxx> wrote in message
news:BAY21-F4A3FC550A52CD86DC14039DAE0@xxxxxxxxxx
> try $conn = odbc_connection("D3_ODBC","","");
>
> not blanks but empty strings
>
> bastien
>
> >From: "Greg Jackson" <gregjackson@xxxxxxxxxxxx>
> >To: php-db@xxxxxxxxxxxxx
> >Subject: odbc_connect() parameters help please
> >Date: Thu, 16 Dec 2004 17:55:59 +1300
> >
> >Hi
> >
> >I'm new to this group, but not to PHP :-)
> >
> >Does anybody know why odbc_connect() requires a username and password to
be
> >supplied as well as the DSN name? This feature is preventing me from
> >accessing a database that can easily be accessed from asp with the
> >following
> >example code:
> >
> ><%
> >set conn=Server.CreateObject("ADODB.Connection")
> >conn.Open"D3_ODBC"
> >set rs=Server.CreateObject("ADODB.recordset")
> >rs.Open "select field1,field2 from tble where field3 like '%search%'",
conn
> >do until rs.EOF
> > for each x in rs.Fields
> > Response.Write(x.name)
> > Response.Write(" = ")
> > Response.Write(x.value & "<br />")
> > next
> > Response.Write("<br />")
> > rs.MoveNext
> >loop
> >rs.Close
> >conn.Close
> >%>
> >
> >Second line of above code: conn.Open"D3_ODBC"
> >Note that no user or password needs to be supplied.
> >
> >For this particular ODBC driver (D3ODBC from Raining Data) there are in
> >fact
> >two sets of user/password parameters specified in the DSN i.e. all four
> >fields of logon info must be supplied correctly on order to connect.
> >
> >I have tried all possible combinations with odbc_connect() (including
> >blanks) in case it simply overrides a couple of the four fields in the
DSN.
> >Nothing works. There is network activity during the connection call and
> >the
> >error message from the driver is the same as when you get the password
> >wrong
> >from something like MSACCESS.
> >
> >Does anybody know of a way around this limitation?
> >
> >Best regards,
> >Greg Jackson
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
