Win XP and ODBC Controller 1

[bigdad]

Hi everybody Ihope someone can help me withj this one:

I need to do a ODBC conection but I don´t know how can I do it at Windows XP PRO. This is because I use the SQLSTRINGCONNECT to do the conection but I don´t know how in XP

Thank´s a lot if somebody may help me


Bigdad

 

[rgbean]

Bigdad,
There is no difference between the SQLSTRINGCONNECT requirements in XP compared to any other OS. What are you using, and why don't you think it's working in XP? Note: You will still need the same security rights no matter what OS you are running, does the XP workstation and your logon not qualify?

Rick

 

[bigdad]

to be more specific: this is my code conection:

conex=SQLSTRINGCONNECT('DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=myfolder\mydatabase.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Sí;Collate=Machine;Null=Sí;Deleted=Sí;')

conex2=SQLSTRINGCONNECT('DSN=Visual FoxPro Database;UID=;PWD=;SourceDB=C:\myfolder\mydatabase.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Sí;Collate=Machine;Null=No;Deleted=No;')
IF conex<0 then
MESSAGEBOX(&quot;Thew conection with your server is incomplete&quot;,48,&quot;Error 0002&quot
thisform.Release
ELSE
another thing
ENDIF
both variables (conex,conex2) are to separate the delete registry from the undelete for some reason. Well my problem is taht this work in all my other OS but in XP don´t doit. Always show me the messagebox...
Bigdad

 

[rgbean]

BigDad,
First I'll assume that the SourceDB in 'conex' has a typo and really has 'c:\' in it.

Did you explictly install the VFP ODBC driver on this XP workstation? It doesn't come installed on XP - it hasn't been included since MDAC 2.5. If you don't have the latest (last) ODBC version of the VFP driver (6.1.8629.1) version, go to

http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp

and get it.

Rick

 

[bigdad]

is not an error 'c:\', this is just because I firts do it the local program (in my PC) and after I change the path with my network path. I´ll go to treat with this ODBC version, to be honest I didn´t know this about ODBC

 

[dejanj]

Bigdad,

I think you will need to install Visual Foxpro ODBC driver in XP by running VFPODBC.MSI from

http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp

as suggested by Rick

Dejan

 

[craigsboyd]

bigdad,

Create an new empty text document on your computer and rename it &quot;ConStr.udl&quot; (this is a Microsoft Data Link file extension), then double-click on it and set up your data connection exactly as you need it in the dialog that pops up (test connection) click OK to save and close udl file. Then open that udl file up with Notepad and Copy & Paste the connection string out of it into your code.

Slighthaze = NULL