Sorry Dan, In a DBMS Action, the query should be:
<@LITERAL VALUE="SELECT @@VERSION"> Cheers..... > -----Original Message----- > From: Scott Cadillac [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 27, 2003 9:41 PM > To: [EMAIL PROTECTED] > Subject: RE: Witango-Talk: Driver Compatibility? > > > Hi Dan, > > The 2000.81.9031.38 number sounds like the SQL ODBC Client > library according > to the following link - which just means you've got the > latest MDAC 2.7 SP1 > kit, which is a good thing. > > http://support.microsoft.com/default.aspx?scid=/support/servic > epacks/MDAC/2. > 71/ManifestUSA.asp > > Try the following query in a DBMS Action: > > SELECT @@VERSION > > The above will give you more useful information on the actual database > server. > > And Ben is right, SQL Server can be a funny creature, "when" > installed with > anything other than the default settings. Find out from these > IT guys what > things they might have changed during install. > > SQL Server (and Witango) is happiest with the default settings, but if > anything has changed during install - like specifying the database as > case-sensitive, then you're going to have trouble. > > Find out exactly what the IT guys did during install. > Sometimes thinking > you're clever produces the opposite effect. > > Good Luck. Cheers.... > > Scott Cadillac, > Witango.org - http://witango.org > 403-281-6090 - [EMAIL PROTECTED] > -- > Information for the Witango Developer Community > --------------------- > > XML-Extranet - http://xmlx.ca > 403-281-6090 - [EMAIL PROTECTED] > -- > Well-formed Development (for hire) > --------------------- > > > > -----Original Message----- > > From: Ben Johansen [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 27, 2003 6:17 PM > > To: [EMAIL PROTECTED] > > Subject: RE: Witango-Talk: Driver Compatibility? > > > > > > SQL Server is a funny creature. There are setting built into > > a database > > install like date format and null interpretation. > > > > It is likely you need to query you SQL Server setup and > then see if it > > matches on the key settings. > > > > Ben Johansen - http://www.pcforge.com > > Authorized Witango Reseller > http://www.pcforge.com/WitangoGoodies.htm > > Authorized MDaemon Mail Server Reseller > > http://www.pcforge.com/AltN.htm > > > > > > -----Original Message----- > > From: Dan Stein [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 27, 2003 4:52 PM > > To: [EMAIL PROTECTED] > > Subject: Witango-Talk: Driver Compatibility? > > > > I moved files to a new server today and I am having lots of strange > > behavior. Witango barfing on taf files that were fine > before. Entering > > 100 > > instead of 1 in the database. > > > > I did not build this machine the IT guys did. > > > > The SQL driver for SQL 2000 is version 2000.81.9031.38 > > > > Never saw a version number like that. > > > > Does anyone know what version that would be and if it works > with 5.062 > > and > > if not how do we get the right driver on there anyway? > > > > > > -- > > Dan Stein > > Digital Software Solutions > > 799 Evergreen Circle > > Telford PA 18969 > > Land: 215-799-0192 > > Mobile: 610-256-2843 > > Fax 413-410-9682 > > FMP, WiTango, EDI,SQL 2000 > > [EMAIL PROTECTED] > > www.dss-db.com > > > > > > ______________________________________________________________ > > __________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > > ______________________________________________________________ > > __________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
