Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts

    SQLServer : "ODBC driver does not support the requested properties."

    connection string:
    Code:
    Driver={SQL Server};Server=10.2.1.17;UID=**********;PWD=**********;DATABASE=**********"
    sql:
    Code:
    SELECT [tblFiles].[id], [tblFiles].[fileName], [tblFiles].[fileType], [tblFiles].[fileCaption], [tblFiles].[groupingID], [tblGroupings].[grouping] FROM [tblFiles] INNER JOIN [tblGroupings] ON [tblFiles.groupingID] = [tblGroupings].[id] ORDER BY [tblFiles].[groupingID], [tblFiles].[fileName]
    DOH As soon as I posted it I saw the SQL typo Sorry, false alarm... nothing to see here... move along...
    Last edited by Spudhead; 09-21-2005 at 08:25 AM.

  • #2
    Regular Coder harlequin2k5's Avatar
    Join Date
    Sep 2005
    Location
    Holiday, FL
    Posts
    635
    Thanks
    18
    Thanked 0 Times in 0 Posts

    Exclamation Is it possible you have the answer I'm looking for???

    Spud -

    I saw your post and I have to ask - is your db setup for remote access?

    Driver={SQL Server};Server=10.2.1.17;UID=**********;PWD=**********;DATABASE=**********"
    I just installed sql server on one of our computers hoping that I could then make my database available for remote access by using its ip address - is that what you've done here?

    Please oh please say yes and I might even buy ya lunch

    Edit: I forgot to ask if you were using vb or access or a browser to get to database?
    Last edited by harlequin2k5; 09-21-2005 at 03:08 PM.


  •  

    Posting Permissions

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