HOW TO CREATE ODBC CONNECTION PROGRAMMICALLY ??

create the connection and view programmically.
However, there is an error. Please give me a hand

OPEN DATABASE d:\data\account.dbc
SET DATABASE TO "account"
IF INDBC("acct1","CONNECTION") = .F.

Create connection acct1 ;
connstring;
'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc';


CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM
arinvheader


endif

Thanks in advance
from agnes

Leemi
Tue Feb 03 13:10:30 CST 2004

Hi Agnes:

This article shows how to create the a DSNless connection:

155392 HOWTO: Creating a Connection to SQL Server Without a Datasource
http://support.microsoft.com/?id=155392

This article shows how to create the view using code:

137944 HOWTO: How to Create a Remote Connection or View Programmatically
http://support.microsoft.com/?id=137944

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>create the connection and view programmically.
>However, there is an error. Please give me a hand

>OPEN DATABASE d:\data\account.dbc
>SET DATABASE TO "account"
>IF INDBC("acct1","CONNECTION") = .F.

>Create connection acct1 ;
>connstring;
>'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc';


>CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM
>arinvheader


>endif

>Thanks in advance
>from agnes

Agnes
Wed Feb 04 02:17:11 CST 2004

Thanks a lot.
I try to use support.microsoft.com ,input ODBC and click' search'.
However, didn't find any other related topic
FromAgnes
"Lee Mitchell" <Leemi@online.microsoft.com> ¦b¶l¥ó
news:IXgjy$o6DHA.1348@cpmsftngxa07.phx.gbl ¤¤¼¶¼g...
> Hi Agnes:
>
> This article shows how to create the a DSNless connection:
>
> 155392 HOWTO: Creating a Connection to SQL Server Without a Datasource
> http://support.microsoft.com/?id=155392
>
> This article shows how to create the view using code:
>
> 137944 HOWTO: How to Create a Remote Connection or View Programmatically
> http://support.microsoft.com/?id=137944
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>
> >create the connection and view programmically.
> >However, there is an error. Please give me a hand
>
> >OPEN DATABASE d:\data\account.dbc
> >SET DATABASE TO "account"
> >IF INDBC("acct1","CONNECTION") = .F.
>
> >Create connection acct1 ;
> >connstring;
> >'Driver={Microsoft Visual Foxpro Driver};DBQ=d:\data\account.dbc';
>
>
> >CREATE sql VIEW arinvtest REMOTE CONNECTION acct1 AS SELECT * FROM
> >arinvheader
>
>
> >endif
>
> >Thanks in advance
> >from agnes
>

anonymous
Wed Feb 04 09:41:05 CST 2004

Please try to use SQLCONNECT(<data source name>, ...

and refrain from using view

Try using the functions that start with SQL.... i.e
SQLEXEC(<handle>, <SQL statement>, <cursorname>

Hardcoded SQL statements are more flexible and powerful than view