MS SQL Express

[tekyros]

Hi,

how can i do a query on the MS SQL Express 2005, i found some exemples here but not work, i tried the DSN-Test (http://www.purebasicpower.de/downloads/DSN-Test.zip) but it return this:

MakeConnection ok
DeleteConnection ok

someone know hot to do this?
if possible, post a example using the DSN-Test... or other...
Ty

[Haruks]

Hello,

Where you doubt on the "DSN-TEST"?
when this code return only these 2 lines... your select in invalid...
You are configuring the QUERY? i belive that the query is on the line 286

It help you?

[ABBKlaus]

Welcome tekyros to the forums,

well i guess you haven´t changed something in the example ?

You have to set this variables according to your SQL-Express installation :

Code: Select all

Server$="COMPUTERNAME\SQLEXPRESS" ; <- Computername + instance name
Database$="TEST" ; <- the database must exist
UID$="sa" ; Username
PWD$="test" ; Password

If you have installed SQL-Express without choosing the appropriate login type, you should install it again with login type "username and password" !

[Haruks]

ABBKlaus

Can this example do a query using a Windows authentication?

Example using the OSQL.exe (utility of MS SQL)
osql -E -S .\SQLEXPRESS -d database -Q "select * from table"

-E = the user that run the app will do the query.. without enter the user and password...

Thank you!