Re: odbc with vfp

Hi Agnes,

Have you considered using the FoxPro and Visual FoxPro OLE DB data provider,
downloadable from msdn.microsoft.com/vfoxpro/downloads/updates? A basic
connection string is "Provider = VfpOleDB.1;Data Source = D:\Temp;" . You'll
need quotes around the data source string if it has spaces in it.

I'm not sure what you mean about security on the server. The account the ASP
process runs under needs to have file permissions to the directory where the
DBFs are located.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx


"Agnes" <agnes@xxxxxxxxxxxxxxxxxx> wrote in message
news:u0PafaUwGHA.4272@xxxxxxxxxxxxxxxxxxxxxxx
I am new bie in asp.net and start my first asp.net.
my database is vfp , i need to create the ODBC connection and got two
questions
(1)I cannot go to my client server to setup ODBC since the security level
, they disallow me to touch the server.
can I create an odbc connection programmically ?? [ I can do it when I use
asp]
(2)in my global.asp .(it is the sql server connection sample)
'Session("ConnectionAuth") = "server=DTS-Server;Uid=hls;Pwd=honour;Initial
Catalog=DTS_Master;"
How about ODBC ??

thanks advance






.

Relevant Pages

  • ODBC Connection
    ... I got problem with ODBC connection, I have a product server and a stage ... Dim intTemp As Integer ... and create a instance of login from asp page, ...
    (microsoft.public.sqlserver.odbc)
  • Re: connect foxpro to sql server and copy table
    ... Could not locate registry entry for OLE DB provider 'VFPOLEDB'. ... You can use a SQL Server Linked Server: ... be sure you have the latest FoxPro and Visual FoxPro OLE DB data ... I would like to copy a table from a foxpro database to a sql server. ...
    (microsoft.public.data.odbc)
  • RE: Trouble with Windows Server 2003
    ... I was looking in the wrong direction with the security issues as you pointed ... referencing an ODBC connection in the ODBC configuration of the computer. ... Data Sources in Control Panel on your XP systems, the Script may have ... Server it may not have that System DSN configured the script would fail even ...
    (microsoft.public.scripting.vbscript)
  • MSDE and ODBC making Connections
    ... the server drop down box for the SQL Server driver. ... ODBC connection in order to work with the MSDE session. ... This is on a WinXP box, there is also Visual Studio 6 and .NET, SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: outside Access to IIS server
    ... I created, with your help, a virtual server that answers to the right address. ... I also need him to have the ability to do an ODBC connection and to run CDONTS. ... > I am having a gentleman, emhasis on MAN and not kid, working on my web site. ... If you have a firewall, it would be easy to allow him VPN (even a simple ...
    (microsoft.public.inetserver.iis)