Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

ODBC connector not accessing data

  
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  Newbie help  
Author Message
cmerrick

External


Since: Sep 04, 2003
Posts: 2



(Msg. 1) Posted: Thu Sep 04, 2003 12:10 pm
Post subject: ODBC connector not accessing data
Archived from groups: microsoft>public>inetserver>iis (more info?)
We have created a photo management web application using
perl and ms access. I have configured the ODBC System DSN
to pull data from a database located on another server.
When accesing the page, data from the database is not
displayed. If I put the mdb file on the same server that
is running IIS and configure the ODBC connector to pull
from the local database, the page is displayed fine. Any
ideas as to what the issue could be? I have tried
searching Technet and googled, but have not found any
answers.

Thank you,
Carl Merrick

 >> Stay informed about: ODBC connector not accessing data 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Thu Sep 04, 2003 5:43 pm
Post subject: Re: ODBC connector not accessing data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Carl Merrick" <cmerrick DeleteThis @enfield.org> wrote in message
news:1ee801c372ff$19a29c20$a601280a@phx.gbl...
 > We have created a photo management web application using
 > perl and ms access. I have configured the ODBC System DSN
 > to pull data from a database located on another server.
 > When accesing the page, data from the database is not
 > displayed. If I put the mdb file on the same server that
 > is running IIS and configure the ODBC connector to pull
 > from the local database, the page is displayed fine. Any
 > ideas as to what the issue could be? I have tried
 > searching Technet and googled, but have not found any
 > answers.

This is not exactly the same but may give you an idea on where to start:
<a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2168" target="_blank">http://www.aspfaq.com/show.asp?id=2168</a>

When you "test" the DSN, does it work?

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: ODBC connector not accessing data 
Back to top
Login to vote
cmerrick

External


Since: Sep 04, 2003
Posts: 2



(Msg. 3) Posted: Mon Sep 08, 2003 11:33 am
Post subject: Re: ODBC connector not accessing data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Tom, not sure what you mean by "test". I can select the
database across servers without a problem. I can also run
the "repair" procedure from within the system DSN tab for
the production database.


 >-----Original Message-----
 >"Carl Merrick" <cmerrick.TakeThisOut@enfield.org> wrote in message
 >news:1ee801c372ff$19a29c20$a601280a@phx.gbl...
  >> We have created a photo management web application using
  >> perl and ms access. I have configured the ODBC System
DSN
  >> to pull data from a database located on another server.
  >> When accesing the page, data from the database is not
  >> displayed. If I put the mdb file on the same server that
  >> is running IIS and configure the ODBC connector to pull
  >> from the local database, the page is displayed fine. Any
  >> ideas as to what the issue could be? I have tried
  >> searching Technet and googled, but have not found any
  >> answers.
 >
 >This is not exactly the same but may give you an idea on
where to start:
 >http://www.aspfaq.com/show.asp?id=2168
 >
 >When you "test" the DSN, does it work?
 >
 >--
 >Tom Kaminski IIS MVP
 >http://www.iistoolshed.com/ - tools, scripts, and
utilities for running IIS
 >http://mvp.support.microsoft.com/
 >http://www.microsoft.com/windowsserver2003/community/cente
rs/iis/
 >
 >
 >
 >.
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ODBC connector not accessing data 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 4) Posted: Mon Sep 08, 2003 5:04 pm
Post subject: Re: ODBC connector not accessing data [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I was thinking about OLEDB, which apparently you are not using. Follow-up
on the link to the FAQ ...

"Carl Merrick" <cmerrick.TakeThisOut@enfield.org> wrote in message
news:489901c3761e$88f3a070$a601280a@phx.gbl...
 > Tom, not sure what you mean by "test". I can select the
 > database across servers without a problem. I can also run
 > the "repair" procedure from within the system DSN tab for
 > the production database.
 >
 >
  > >-----Original Message-----
  > >"Carl Merrick" <cmerrick.TakeThisOut@enfield.org> wrote in message
  > >news:1ee801c372ff$19a29c20$a601280a@phx.gbl...
   > >> We have created a photo management web application using
   > >> perl and ms access. I have configured the ODBC System
 > DSN
   > >> to pull data from a database located on another server.
   > >> When accesing the page, data from the database is not
   > >> displayed. If I put the mdb file on the same server that
   > >> is running IIS and configure the ODBC connector to pull
   > >> from the local database, the page is displayed fine. Any
   > >> ideas as to what the issue could be? I have tried
   > >> searching Technet and googled, but have not found any
   > >> answers.
  > >
  > >This is not exactly the same but may give you an idea on
 > where to start:
  > >http://www.aspfaq.com/show.asp?id=2168
  > >
  > >When you "test" the DSN, does it work?
  > >
  > >--
  > >Tom Kaminski IIS MVP
  > >http://www.iistoolshed.com/ - tools, scripts, and
 > utilities for running IIS
  > >http://mvp.support.microsoft.com/
  > >http://www.microsoft.com/windowsserver2003/community/cente
 > rs/iis/
  > >
  > >
  > >
  > >.
  > ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: ODBC connector not accessing data 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Data transfer between IIS - How to transfer data from one IIS application to another application in another IIS server?

enctype=multipart/form-data" and IIS - I have built a dynamic form generator in VB. A generated form may contain a File field which enables the user to upload pics, which means i have to submit every form using the enctype=multipart/form-data attribute. Because of this i cant read all the....

add referrers and keyword data to logs - Hi, I'm in the process of trying out a log analyzer and one of the things it says is to add referrers to my logs. How can I do this in IIS 6? Thanks David

Can't POST large amts of data - The data area for system c.. - Ever since upgrading to Windows 2000 SP-latest, my IIS 5 setup won't allow me to post data that posted fine before. Sometimes the POST returns the error (via HTTPODBC and idc/htx file) The data area for system call is too small. I read all about change...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]