Re: Need some help A.S.A.P.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Crazy Pete (crazypete_at_home.nl)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 09:23:11 +0200

Hi

Maybe you can conect to the MS SQL database using MS Access? i don't know?
maybe diverent ODBC driver?
I'm still new to this but just trying to gif you some things you may wanna
try.

Greatings,

   Crazy Pete
"Will" <anonymous@discussions.microsoft.com> schreef in bericht
news:2396c01c45ebe$550b2f10$a301280a@phx.gbl...
> 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!
>
>

Relevant Pages

  • Updated Question - Updating an SQL Database
    ... Using the script below I can only update the first record in ... Dim cnn As ADODB.Connection ... I have an Excel Spreadsheet that is populated from a SQL Database. ...
    (microsoft.public.excel.programming)
  • Problem with Large Query Returns from MS-SQL
    ... I am writing an application that is using DBI to access a MS SQL database ... Where where tableA is around 10 rows, then my test script returns all of the ... I put conditions on the query for the large table that would return only 2 ...
    (perl.dbi.users)
  • SQL-DMO Service already running error
    ... I'm installing an app and it sets up an SQL database. ... SQL-DMO: An instance of this service is already running. ... I stopped the obvious services but then my app's script wouldn't work anymore (it needs SQL Server running, ...
    (microsoft.public.sqlserver.server)
  • Script, Save, Export SQL 2005 Database Diagrams
    ... I've used the code from the post [Script, Save, Export SQL Database ... Diagrams] for a while now... ... I've written a new script for SQL Server 2005, ...
    (comp.databases.ms-sqlserver)
  • Trying to connect to SQL server
    ... I'm trying to use the script below to copy the event logs from our servers ... to a SQL database, but when I run the script it's trying to connect as null. ... Set colRetrievedEvents = objWMIService.ExecQuery _ ...
    (microsoft.public.windows.server.scripting)