Trouble with DoCmd.TransferDatabase acLink, "ODBC Database"

[JGT]

I am testing my Access application with Access FE / SQL Server BE in my home computer (all SW in the same PC)

There is no problem in linking the BE manually to the FE, however when I try this through VBA programming, I get the error 2507 (Db type ODBC Database not installed / doesn’t support the selected operation)

I am puzzled - I did this before on PC with net Server without problems - because the ODBC db is working and the aclink operation is supported.

DoCmd.TransferDatabase acLink, "ODBC Database", Connect_SQL, acTable, "dbo.CSDB", "dbo_CSDB", True

The connect string I copied form the properties definition

Connect_SQL = "ODBC;Description=MASDAT_BESQL;DRIVER=SQL Server;SERVER=DESK_TOP\SQLExpress;APP=Microsoft Office 2003;WSID=DESK_TOP;DATABASE=MASDAT_BESQL;Trusted_Connection=Yes"

Any idea what’s wrong?

Thank you for any help.

 

[SQL_Hell]

Hi there

Your connection string doesn't look quite right to me, use the following site its very useful

http://www.connectionstrings.com/

One more thing use OLEDB it's much faster than ODBC