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

[Spudhead]

connection string:

Driver={SQL Server};Server=10.2.1.17;UID=**********;PWD=**********;DATABASE=**********"


sql:

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 :o As soon as I posted it I saw the SQL typo :D Sorry, false alarm... nothing to see here... move along...

[harlequin2k5]

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 :D

Edit: I forgot to ask if you were using vb or access or a browser to get to database?