Page 2 of 2 <12
Topic Options
#137282 - 2005-04-13 11:00 PM Re: Help with test DB Connection
maciep Offline
Korg Regular
*****

Registered: 2002-06-14
Posts: 947
Loc: Pittsburgh
I think you're still missing the point. Shawn (and I) are talking about the actual function itself. You have the parameters in the function itself incorrectly named.

Not here
Code:

$ConnDSN = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=test;PASSWORD='';OPTION=3;"



But here
Code:

Function DBConnOpen($objConn, optional $ConnTimeout, optional $CmdTimeout)



I'm not sure how else to explain it. Post your entire script again so that we're all on the same page.

Top
#137283 - 2005-04-13 11:53 PM Re: Help with test DB Connection
thepip3r Offline
Hey THIS is FUN
*****

Registered: 2005-03-02
Posts: 350
Well I just wanted to let you all know that once I downloaded the MySQL ODBC driver, the script worked great for my test information. A big, "thank you" to all who continually helped me through this process...
Top
#137284 - 2005-04-14 10:45 PM Re: Help with test DB Connection
thepip3r Offline
Hey THIS is FUN
*****

Registered: 2005-03-02
Posts: 350
Ok, the problem with $objConn was with calling it as the wrong var name in one of the UDFs. i was using $objConn instead of $ConnDSN which the UDF wanted.
Top
#137285 - 2005-04-14 10:49 PM Re: Help with test DB Connection
maciep Offline
Korg Regular
*****

Registered: 2002-06-14
Posts: 947
Loc: Pittsburgh
So you understand what we were trying to tell you now? That's good.

In general, there's no need to ever make changes to a udf provided here, especially if you're new to UDFs. They are built to work as provided.

Top
Page 2 of 2 <12


Moderator:  Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart 
Hop to:
Shout Box

Who's Online
0 registered and 568 anonymous users online.
Newest Members
SERoyalty, mytar, Gabriel, Alex_Evos, Dansen
17869 Registered Users

Generated in 0.056 seconds in which 0.028 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org