Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: vbscript connection string

    I have been using vbscript for some time now and have been using a MS access database. I now need to access a SQL Server database. I have a datbase called "archive" and we used a script to create the tables with a user called "dicom". When I use a tool to see the tables - they are there but the owner is "ado" not "dicom"! Anyway, when I create the connectstring I get connected but I get this error:

    Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dicompatients'.

    I can select data from the system tables though! Any help/ideas?

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: vbscript connection string

    First of all, why are you still using ODBC? Use the native OLE DB provider for SQL Server!

    Your error, however, seems to come from an SQL statement, where you try to select or DML the table 'dicompatients'. From your context, I guess you just omitted the point, so you should use 'dicom.patients', or just 'patients', depending on your current user personality.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •