471,065 Members | 1,533 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,065 software developers and data experts.

Connecting an ADP to a remote MSSQL database on the same network

I installed MSSQL 2000 on my desktop (running NT 2000). No problem. I created an adp and attached it to a database within MSSQL 2000, no problem.

When I go into MS Access, on another PC (running Windows XP Pro) on the same network, and try to create a using 'Project(Existing Data)' and connect it to MSSQL 2000 on my desktop, I fill in the Data Link Properties '1. Select or enter server name', no problem, '2. I click on Use Windows NT integrated security ',no problem. On '3. Select the database on the server', I get the following message -
SQL Error [DBNETLIB]{ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

I've been to more websites then I can count to try and resolve this error to no avail. Could someone give me a simple solutions, or at least some direction on this.

Thanks in advance for any help you can provide.

Jan 25 '07 #1
1 1791
1,017 Expert 512MB
Try to create DSN instead and use it instead of Server name.

Good Luck
Jan 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by bigoxygen | last post: by
1 post views Thread by Jim Bayers | last post: by
reply views Thread by Suresh | last post: by
10 posts views Thread by mairhtin o'feannag | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.