Changing file DSN path at runtime - Xtreme Visual Basic Talk

03-13-2004, 12:40 PM

caneye

Newcomer

Join Date: Aug 2003

Posts: 5

Changing file DSN path at runtime

I am creating an ActiveX control that will conect to a foxpro free table.
The activex will recieve a "data path" from it's parent app when activated.

I am currently connected to the free table via "file dsn". Is there any way that I can chage the data path of the file dsn at runtime?

my current code is as follows:
recordsetX.Open "Select * From freetable.dbf", "filedsn=mydsn;", adOpenDynamic, adLockOptimistic

I am able to access the table freetable but if the parent app moves the location of free table I need to be able to change the filedsn path accordingly.

Thanks in advance
Caneye

04-20-2004, 10:03 AM

Peperl

Senior Contributor

Join Date: Apr 2003

Location: Cartagena, Spain

Posts: 1,371

Code:

Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Long, ByVal fRequest As Long, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Long

with this api I have created and deleted system dsn dynamically, i suposse that the same function works to create, erease and modify what you are asking about

Search in www.AllApi.NET about SQLConfigDataSource

__________________
Pri Oh Persia

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Forum Rules

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with changing file attributes... what's wrong with my code?	Schroeder	File I/O and Registry	3	07-31-2003 05:44 PM
File Problems: Files Not Closing etc.	Templeton Peck	General	5	03-29-2003 11:34 PM
File format problem	kingesk	General	1	09-08-2000 04:52 PM