Thanks for your response Nadya.

There was a suggestion by Sergey about creating connection string using and empty file, is it the same string that you have mentioned below, but then again I guess it used ODBC.

Test is Test.dbf in the current directory or is it the DSN. I also don't see a VFP mention in the codes will it work for VFP?


>>Hi all
>>
>>I use Report Manager for reporting. RM uses ADO for querying data from the DBC's, MS suggests that we should use OLEDB (correct?) to query data as ODBC drivers for VFP is discontinued in 2.6/7.
>>
>>Can ADO use OLEDB? Right now I have to open Data Sources (ODBC) to specify DSN and then use it in RM. How to make things future proof with exisiting stuff.
>>
>>Please clarify as I have things workign alright but theories in my head is not clear.
>
>Sorry, I'm not an expert, but you can use either of them. Here is a message from Thomas Whiteley (though I didn't make it with OLE DB - will try again later on):
>
>

>Dim strConn
>
>'strConn = "Provider=SQLOLEDB; Data Source=" & _
>' Request.ServerVariables("SERVER_NAME") & _
>' "; Initial Catalog=pubs; User ID=sa; Password="
>
>' ODBC DSN-less connection...
>''strConn = "Driver={SQL SERVER};SERVER=LOCALHOST;DATABASE=Test;UID=SA;PWD=;"
>
>'strConn = "Provider={SQL SERVER};Persist Security Info=True;UID=UserID;PWD=Password;Initial Catalog=QMDS;Data Source=TVS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SomeID;Use Encryption for Data=False;Tag with column collation when possible=False"
>
>strConn = "Driver={SQL SERVER};SERVER=VSQ;DATABASE=Test;UID=UserID;PWD=Password;"
>
>'strConn = "Driver={SQL SERVER};SERVER=TDEV;DATABASE=Test;UID=UserID;PWD=Password;"
>
>'OLEDB DSN-less connection...
>'strConn = "Provider=SQLOLEDB.1;Server=TDEV;Database=Test;UID=sa;PWD=;"
>
>

>
>
>Try using each one to see the difference by commenting out all but the one in use. It includes OLEDB and ODBC with DSN-less connections.
>===========================================================
>I hope I don't reveal the important UserIDs and Passwords (I replaced them with UserID, Password keywords)