Hello All,
I've just spent the better part of a day trying to configure SQL Express to allow me to create an ODBC connection. When I do create one via Control Panel/Admin/ODBC it tells me that its timing out on the connection (localhost) and the problem is probably that SQL Server Express comes configured NOT to allow remote connections. I've enabled TCP/IP and named pipes, allowed remote connections, enabled the SQL Browser, and just about everything I;ve read in the docs and forums.
Am I missing the obvious?
Kind Regards,
Pat.
Pat,
I guess you are using (localhost) as the target server which is invalid. Either you can use (local)\sqlexpress or localhost\sqlexpress to connect to local sql express instance, a name instance.
Thanks,
Nan
|||Nan,
You are bang on! Thank you very much.
I've created a test user database, but when i attempt to "get external data/link tables" in access, I can't see my database, only all the system tables.
Any thoughts?
Kind Regards,
Pat.
|||Did you specify your database name while creating DSN?
It's under 'Change the default dabase to' checkbox.
|||Thank you, gavrilenko_s - that did it.
To both you and Nan, if in Dublin, send me an email - there are pints of guinness woith your names on them.
appreciatively,
Pat Backowski
Consider this thread closed and solved - well done, lads!
|||Holy Telemundo, Batman! If I hadn't found this thread, I was seriously considering just using MySQL for my app. I've talked to a few guys who have had this problem too. You may want to include a hint about this solution in the next revision of the connectivity tools so people don't go wasting so much time on what could have been a simple solution.
No comments:
Post a Comment