MS SQL Server 2005 Question

[billhsln]

Does any one use MS SQL Server 2005?  I need to know how to open and close the database for use under IonicWind Basic.


Thanks,
Bill

[GWS]

Hi Bill,

Take a look at ..
http://www.ionicwind.com/forums/index.php?topic=2869.0

Maybe that will help ..

Graham

[billhsln]

I need MS SQL not MySQL.  All I need to really know is how to open the data base, after that every thing else should basically be standard IWB code.  I really need to know if IWB can do it.  If not, I may have to learn VB.  I need to be able to manipulate the database for Work.


Thanks,
Bill

[docmann]

Hey Bill,
I believe these may be of help to ya:

http://www.connectionstrings.com/
Based of the resources above, it appears that there may be some differences in the connect strings based on both the version and implementation of the SQL Server you are working with.

Here's another that kinda verifies that:
http://www.dofactory.com/Connect/Connect.aspx

Hope that is of help to ya somehow.
-Doc-

[GWS]

Hi Doc .. 

I've searched all over in the IWB archives, the PureBasic site, the Web, and the Liberty Basic companion .. and there are no references I can find for accessing Microsoft's Sequel Server databases from ordinary Basic.

On the Web, all comments relate to VB, .NET and C - and they talk about the complicated access strings you mention. 

It seems a bit like cracking a safe  - good old Microsoft.

all the best,

Graham

[billhsln]

Thanks for looking Graham, I have also looked all over the place and tried using 'database_test.iwb' and 'direct_odbc.iwb'.  Modified 'database_test.iwb' to try every driver it came up with to load table (no luck).  'direct_odbc.iwb' complains when I compile about missing endif in sql.inc.  Looked at sql.inc, it has 5 $ifndef and 5 $endif, so don't understand the problem with it.


I am going to put the strings from the website that docmann gave me directly into the 'database_test.iwb' and give them a try.


So, thanks for the help. I will keep trying.  I don't want to have to learn VB, never could understand C, and .NET is way beyond me.


Thanks again,
Bill