Connect String with DSN parameter not defaulting to the specified DSN

[mozgheib]

Hello,

I am recreating my external links by dropping
them and then recreating them and finally refreshing.
Now when asked to log on I am presented with the "Select
data source" dialog box despite the fact I have specfied
my dsn already in my connect statement see below :

tdfLinked.Connect = "Odbc; dsn = oriontest; database = scd"


What am I doing wrong.


Thanks.

 

[scriverb]

Don't know if this makes a difference but I have always created this connect string without spaces.

tdfLinked.Connect = "Odbc;dsn=oriontest;database=scd"

I can't test this here at my home office as I don't have access to an ODBC connection but when I active with these I never included spaces and never had a problem.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]