Thanks I skipped all that went back to the old machine cleaned it up of unneeded files and all is well. I never wanted to make the switch anyway.
on 8/28/03 12:15, Scott Cadillac at [EMAIL PROTECTED] wrote: > 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 > -- 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
