473,326 Members | 2,061 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Connecting through .adp file (not working on Vista/SQL Server 2008)

Hello everyone,

I am having a weird problem that I can't seem to find an answer to anywhere online so I thought I'd finally post a question.

I am trying to connect to a remote SQL Server through an Access .adp file (Access 2007) through the Data Link Properties. It works just fine on my laptop, which is running Windows XP and has SQL Server Manager 2005 installed. However, I can't get it to connect on my PC, which is running Windows Vista and has SQL Server Manager 2008 installed. I still am able to connect to the database (on both) through the Management Studio (both versions), but the PC won't connect through an .adp file which is really weird. I checked and the server allows remote connections and the "SQL Server Browser" service is installed. Any ideas?

The error I get (when connecting to an .adp via the Vista PC) is:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Login failed. Catalog information cannot be retrieved.


Thanks for your help!

Zach
May 23 '09 #1
0 2487

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

Similar topics

7
by: TerpZebra | last post by:
I am having difficulty connecting to SQL Server 2000 on one of our servers via a VB6 program on Vista. I can connect fine to a different server, but it gives me the following error with the server...
6
by: Miro | last post by:
I can run an exe ( and its install ) i have created on my machine. The exe has a button that populates a dataset and then shoots it to a crystal report. But... Installing the setup.exe on my...
4
by: Miro | last post by:
<i have also added this reply to the other newsgroup - now that I have realizd ( and assuming ) it is not a localized error directly to vb.> I have found this link on the website:...
65
by: Hongyu | last post by:
Dear all: I am trying to write to a file with full directory name and file name specified (./outdir/mytestout.txt where . is the current directory) in C programming language and under Unix, but...
0
by: Gabriel Genellina | last post by:
En Tue, 12 Aug 2008 00:48:21 -0300, Prof. William Battersea <williambattersea@gmail.comescribi�: This is mostly a network administrative problem... Both machines are in the SAME workgroup,...
8
by: raylopez99 | last post by:
I have the latest version of Visual Studio 2008 Professional, which allows you to create resource files (this is the .resx file, no?), unlike the Express version, which does not. I am trying to...
0
by: raylopez99 | last post by:
From the Wall Street Journal. RL August 22, 2008, 3:35 pm Windows Vista: Coming Soon to Your Work Computer? Bad news for workers: Some of you may be using Windows Vista sooner than you think....
2
by: =?Utf-8?B?U2FsYW1FbGlhcw==?= | last post by:
have a fresh new install of VS2008 on Vista 64Bit and SQL management studio. I manage to connect to the sql 2008 from within the management studio but when I am not able to create a database...
2
by: bobt1991 | last post by:
I just installed Microsoft Visual Studio 2008 Express edition, and it installs some sort of stripped down version of SQL Server. It comes with no tools for connecting to your "local" database,...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.