Need some help A.S.A.P.
From: Will (anonymous_at_discussions.microsoft.com)
Date: 06/30/04
- Next message: Bill: "Blank field in column"
- Previous message: Stefaan Dewulf: "Error using QA"
- Next in thread: Crazy Pete: "Re: Need some help A.S.A.P."
- Reply: Crazy Pete: "Re: Need some help A.S.A.P."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 30 Jun 2004 09:21:43 -0700
Hi Folks,
I'm having a bit of trouble updating my script. I have a
script used for MS Access and I need to transfer it to be
compatible with MS SQL Server. When I run the script it
gives the error
''ODBC driver does not support the requested
properties.''
This is the line of the script
that I have to change to work with access:
''oRS.Open SqlTxt , oConn'' and the sql text is:
''Sqltxt = "SELECT MasterServer, Max(JobId) AS MaxJobId
FROM Jobs GROUP BY MasterServer ORDER BY MasterServer;".
Could anybody please help me out in solving this problem?
Cheers!
- Next message: Bill: "Blank field in column"
- Previous message: Stefaan Dewulf: "Error using QA"
- Next in thread: Crazy Pete: "Re: Need some help A.S.A.P."
- Reply: Crazy Pete: "Re: Need some help A.S.A.P."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
