Connection Strings

[Rhysliverpool]

I want to setup an ASP page to a pervasive SQL server database. Can anyone help with the connection string.

 

[TomKane]

Do you have microsoft data link? If you have you can use it to build your connection string. Failing that, if you intend to use ADO then you can create a ado recordset control on a vb6 form and use the properties section to create yourself a connection string.

This is the one that we use:

"Provider=MSDASQL.1;Persist Security Info=False;Data Source=" & strBranchDataSetName

I think it is a bit different in .NET however....

 

[Rhysliverpool]

I have managed to set up the connection string, i get the error message in my browser now saying cant find the ODBC driver. However i do have the Pervasive drive installed on my machine and on the web server.

 

[mirtheil]

You need to make sure that the DSN you're using (if you're using a DSN) is a System DSN. It cannot be a User of File DSN. If you're using a DSNless connection, post the Connection string and we'll take a look at it.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[mgraf]

Hi
I hope I am not too late with my connectionstring.

Advice: For Pervasive 7.0 use the MS generic SQL driver:
Call conn.Open("Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=DRIVER={Pervasive Software ODBC-32};DATAPATH=P:\Pam\Client;UID=;DDFPATH=P:\Pam\Client;BOB=;NullEnabled=no;FeaturesUsed=yes;LoginScript=;AccessFriendly=no;DateFormat=;TranslateDLL=;TranslateOption=;&quot

I suggest that you change the 2 paths P:\Pam\Client to your paths and it works

best regards
Whatever specialist
Mike