473,326 Members | 2,126 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.

How to connect to .adp file

D
Is it possible to connect to a .adp file? I'm pulling data from a sql
server, but my files are stored on a different server? I'm not sure how
to connect across servers so I thought using an .adp file would be the
easiest solution?

Jan 22 '07 #1
4 1318

ADP as in Access Data Project? They don't have any data--just
connection info to the MSSQL database. You're better off using
ADO.NET / SqlClient classes directly.

HTH,

Sam
------------------------------------------------------------
We're hiring! B-Line Medical is seeking Mid/Sr. .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.
On 22 Jan 2007 11:30:38 -0800, "D" <em*******@comcast.netwrote:
>Is it possible to connect to a .adp file? I'm pulling data from a sql
server, but my files are stored on a different server? I'm not sure how
to connect across servers so I thought using an .adp file would be the
easiest solution?
Jan 22 '07 #2
D

Samuel R. Neff wrote:
ADP as in Access Data Project? They don't have any data--just
connection info to the MSSQL database. You're better off using
ADO.NET / SqlClient classes directly.

HTH,

Sam
------------------------------------------------------------
We're hiring! B-Line Medical is seeking Mid/Sr. .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.
On 22 Jan 2007 11:30:38 -0800, "D" <em*******@comcast.netwrote:
Is it possible to connect to a .adp file? I'm pulling data from a sql
server, but my files are stored on a different server? I'm not sure how
to connect across servers so I thought using an .adp file would be the
easiest solution?
Thanks Sam - I was able to move my files over to the sql box, and
everything works fine except now I run in to a slightly different
issue. My application is designed to pull records using views and
stored procedures and display in excel. When I run my reports,
sometimes the incorrect file name comes up and displays the year (2007)
and then the file does not populate and provides an error message that
the file could not be found. When I run the stored procedure and views
directly from Query analyzer it takes about 23 seconds to run and
display results...sometimes it takes 10 minutes, depending on the
report. I feel like something is timing out on the front end user
interface but I don't know how to resolve this issue? Any ideas? I
originally thought this was SQL side, but now that I can run these
queries in a matter of minutes, I have to believe it is timing out or
something on the front end.

Jan 23 '07 #3
Since the question is unrelated I would suggest reposign it in a new
thread with an appropriately named subject.

Sam
On 23 Jan 2007 14:06:06 -0800, "D" <em*******@comcast.netwrote:
>
Samuel R. Neff wrote:
>ADP as in Access Data Project? They don't have any data--just
connection info to the MSSQL database. You're better off using
ADO.NET / SqlClient classes directly.

HTH,

Sam
On 22 Jan 2007 11:30:38 -0800, "D" <em*******@comcast.netwrote:
>Is it possible to connect to a .adp file? I'm pulling data from a sql
server, but my files are stored on a different server? I'm not sure how
to connect across servers so I thought using an .adp file would be the
easiest solution?

Thanks Sam - I was able to move my files over to the sql box, and
everything works fine except now I run in to a slightly different
issue. My application is designed to pull records using views and
stored procedures and display in excel. When I run my reports,
sometimes the incorrect file name comes up and displays the year (2007)
and then the file does not populate and provides an error message that
the file could not be found. When I run the stored procedure and views
directly from Query analyzer it takes about 23 seconds to run and
display results...sometimes it takes 10 minutes, depending on the
report. I feel like something is timing out on the front end user
interface but I don't know how to resolve this issue? Any ideas? I
originally thought this was SQL side, but now that I can run these
queries in a matter of minutes, I have to believe it is timing out or
something on the front end.
Jan 23 '07 #4
D
Thanks - posting now

Jan 24 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Krista | last post by:
Hi, Hope you guys can help me out~~ I have a config.php file. I want to conncet to my own mysql version. When i run the config.php file as below, i get all successful message. However, when i take...
0
by: Kevin Sage | last post by:
For anyone who is having this problem and want to know the solution. Add this line of code before your connect method call. It loads up some config file that the code behind the scenes needs...
4
by: Ellen K. | last post by:
Hi all, Being that so far I didn't get an answer to my below problem on the Oracle newsgroup, I figured it couldn't hurt to try here. While at my current job I've been working with mostly SQL...
10
by: Ed Stevens | last post by:
A tale of woe, and a question . . . Last week my boss said to me "we've installed DB2 Connect on this Solaris box. Make it work." Now, I've barely seen DB2 Connect on Windows, having fumbled...
5
by: mayamorning123 | last post by:
A comparison among six VSS remote tools including SourceOffSite , SourceAnyWhere, VSS Connect, SourceXT, VSS Remoting, VSS.NET To view the full article, please visit...
2
by: xiuchuanli | last post by:
I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to...
2
by: Mondal | last post by:
Hi, I am using MySQL 5.0 beta and Active Python 2.4. I have the correct version of MySQLdb installed. The problem is that I can't connect to MySQL through the Active Python interactive window. ...
3
by: asemeiks | last post by:
I'm using Access 97, Jet 4.0. the data resides on a Win 2000 domain server. Using .Net 1.1 and IIS 5.0 on a local XPPro computer I am trying connect to a Jet database on the server. If the data...
3
by: beliavsky | last post by:
I want to write a function that writes to an output file if specified and otherwise to standard output. How can I connect a file object to standard output in the code below? I could use an if...
1
by: GNoter | last post by:
Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2; they are not part of a domain. I have a third server, Server3, which is part of a domain and on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.