Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Cannot Create SQL Tables
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

leroyjames
Starting Member

3 Posts

Posted - 18 December 2005 :  07:58:42  Show Profile
I am installing this on a 2003 server using SQLServer
I have set type strDBType="sqlserver"
I have set strTablePrefix="CC_"
I have set strMembertablePrefix= "CC_"
I have set strFilterTablePrefix="CC_"

and my connection string strConnString = "SNITZ" when I run setup I enter my administrative password for the login
Full access to everything
and put newinformation in for the username and password at the bottom of the setup screen.

I continue to get Cannot create table error messages.

Could someone offer some suggestions on what to try next

Thanks.

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 December 2005 :  07:59:38  Show Profile  Send ruirib a Yahoo! Message
Please stop repeated posting of the same topic at once!


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 December 2005 :  08:04:14  Show Profile  Send ruirib a Yahoo! Message
I would recommend two things:

1. Use a SLQOLEDB provider instead of an ODBC one;
2. Check the user you're using to access the DB has table creation permissions.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

leroyjames
Starting Member

3 Posts

Posted - 18 December 2005 :  08:13:38  Show Profile
You should take out the fact that you support DSN's

It doesn't work
I am using my administrative password it has complete access to everything

I did try the SQLOLEDB and it worked

Thanks

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 18 December 2005 :  09:22:58  Show Profile  Send ruirib a Yahoo! Message
It's not the Snitz code that supports DSNs it's ASP itself, we just use it. Probably the issue lies with the way the DSN was setup, though I can't really be sure about that.

Anyway, DSN is something to avoid, IMO, whenever the option to use an OLEDB provider is available.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

leroyjames
Starting Member

3 Posts

Posted - 18 December 2005 :  11:20:03  Show Profile
Thanks,
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts

Posted - 19 December 2005 :  06:21:49  Show Profile  Send pdrg a Yahoo! Message
I'm with Rui on this one - OLEDB providers are more efficinet with newer engines
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07