i have tried made a sample BUT RECEIVE ERROR unable to connect
what i miss?
i can open sql server management studio with localhost\SQLEXPRESS ,
windows autentication
Follow is my dbinfo information
DbInfo( <nDefine>, [<xNewSetting>] ) --> xCurrentSetting
Queries and/or changes information about a database file open in a work area.
#include "dbinfo.ch"
REQUEST SQLMIX
PROC main()
RDDSETDEFAULT( "SQLMIX" )
x_stringa="driver=SQL
Server;Server=localhost\SQLEXPRESS};Database=HBTEST;Trusted_Connection=yes;"
IF RDDINFO( 1001, { "ODBC", x_stringa} )=0
? "Unable connect to the server with string " + x_stringa
RETURN
ENDIF
? RDDINFO(RDDI_EXECUTE, "DROP TABLE hbcountry")
? RDDINFO(RDDI_EXECUTE, "CREATE TABLE hbcountry (CODE char(3), NAME
char(50), RESIDENTS int(11))")
DBUSEAREA( .T.,, "SELECT * FROM hbcountry", "hbcountry" )
? "DBINFO(1)"
? DBINFO(DBI_ISDBF) // 1 /* Does this RDD support DBFs? */
RETURN
2009/11/16 Horodyski Marek (PZUZ) <[email protected]>:
> Mindaugas, dbInfo(1) from sqlmix is returned U.
> Should be .F.
>
> Regards,
> Marek Horodyski
> _______________________________________________
> Harbour mailing list (attachment size limit: 40KB)
> [email protected]
> http://lists.harbour-project.org/mailman/listinfo/harbour
>
--
Massimo Belgrano
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour