front/backend access application--conversion to MSSQL--advice

I have an application that uses Acces as a backend and VBA as front end. Application is secured and is supplied on a CD with setup.exe.

Can I use VB 2005 and MS SQL to achieve the same?

Would I be able to package my application with all the neccessery files (assuming that client does not have any e.g. SQL server) so that multiple front ends can access data from common source?

Would I be able to secure such an application using only VS 2005?

What would I need to quickly learn how to achieve the above ( any books you can suggest maybe)?

You can absolutely use SQL Server Express to ship as part of your application - it is designed for that. You can find a whitepaper with guidance on this at http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/emsqlexcustapp.asp. The whitepaper includes an explanation of how you can use a feature called ClickOnce in Visual Studio/.NET to deploy your client applications. You should also sign up for redistribution rights for Express at http://www.microsoft.com/sql/editions/express/redistregister.mspx.

Thanks< MJ

From SQL SERVER TO MSDE

i have an access application based on sql server
now i was told that for small offices msde is enough and chiper
if it is so can somebody tell me
how to convert the database from sql to msde?
and it cost a lot of code working?
thanks ahead
sam
hi Sam,
Sam wrote:
> i have an access application based on sql server
> now i was told that for small offices msde is enough and chiper
> if it is so can somebody tell me
> how to convert the database from sql to msde?
> and it cost a lot of code working?
MSDE has some constraints built in it, but it is the very same engine as SQL
Server is... so you do not have to worry about "converting" SQL Server
databases into MSDE databases as they are the same...
MSDE has a limit on the file size it's databases data file(s) can reach,
that's to say 2gb per database data files...
other limits are about missing feature, like Full Text indexes, olap
features, partial replication, and so on... but as long as you "stay" into
the architectural limits and your applications do not cover missing features
you will be ok.. further info at
http://www.microsoft.com/sql/msde/pr...o/default.mspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

From Excel to Analysis Services

Have any of you heard of an application that makes it possible for normal business people with no IT knowledge to directly from Excel “publish” a table to SQL Server and Analysis Services?

I’m searching for an Excel add-in that sends the data in a normal Excel table with a few dimensions and some measures, as a data set (preferably via a web service over https) to a server application. The server creates a table in a specific SQL Server database, and automatically creates a cube in a specific analysis service database. The cube on the server is automatically processed and the data is available to all users in the company using their BI GUI.

Any ideas where to find such tool?

/Erik

I don't know any turnkey solution which can solve your entire problem. But there are enough off-the-shelf technologies, such as SQL Server Integration Service, out there from which you can build your own solution.

Alternatively, take a look at the Visual Studio Tools for Office (the .Net interop assemblies for Office essenially) as you can pretty easily write some code behind your XL spreadsheet (or as an XL add-in) yourself that can pull data off the sheet into an ADO.Net recordset which you can then push to SQL Server (or XML or many other formats for that matter).

|||You can also use pivot tables in excel and publish cubes on the web using OWC.|||

That is exactly what I would prefer. I use OWC for publishing Aanalysis Services Cube data thru Excel onto Http:// - a basic publication site. It works fine for IT and Biz community with no maintenace. - raj

Frequent errors in Application Event Viewer

Hi all,
I encounter many of this errors in Application event viewer regarding
SQL server 2005:
Type:Error
Date:07/03/2008
Time:8.54.24
Event:19019
Source:MSSQL$INSTNEW
Category:Failover
User:N/A
Computer:NEW
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Type:Error
Date:07/03/2008
Time:8.54.24
Event:19019
Source:MSSQL$INSTNEW
Category:Failover
User:N/A
Computer:NEW
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]TCP Provider: An existing
connection was
forcibly closed by the remote host.
Type:Error
Date:07/03/2008
Time:8.54.24
Event:19019
Source:MSSQL$INSTNEW
Category:Failover
User:N/A
Computer:NEW
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]Communication link failure
Type:Error
Date:07/03/2008
Time:8.54.24
Event:19019
Source:MSSQL$INSTNEW
Category:Failover
User:N/A
Computer:NEW
Description:
[sqsrvres] OnlineThread: QP is not online.
They occours every time in this order. 6-7 times a day.
I've searched but individually, they seem to be generics errors.
Could you help me?
Thanks in advance
Tony
That is the cluster service checking to see if the SQL Server is responsive.
Get enough of those in a row, and cluster serv tries to restart or failover
the sql group
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Tony_da_Roma" <killerloop@.post.com> wrote in message
news:ff950762-ed63-4c69-9e5e-f45a5386b2e4@.n58g2000hsf.googlegroups.com...
> Hi all,
> I encounter many of this errors in Application event viewer regarding
> SQL server 2005:
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
> message = [Microsoft][SQL Native Client]TCP Provider: An existing
> connection was
> forcibly closed by the remote host.
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
> message = [Microsoft][SQL Native Client]Communication link failure
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] OnlineThread: QP is not online.
> They occours every time in this order. 6-7 times a day.
> I've searched but individually, they seem to be generics errors.
> Could you help me?
> Thanks in advance
> Tony

Frequent errors in Application Event Viewer

Hi all,
I encounter many of this errors in Application event viewer regarding
SQL server 2005:
Type: Error
Date: 07/03/2008
Time: 8.54.24
Event: 19019
Source: MSSQL$INSTNEW
Category: Failover
User: N/A
Computer: NEW
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Type: Error
Date: 07/03/2008
Time: 8.54.24
Event: 19019
Source: MSSQL$INSTNEW
Category: Failover
User: N/A
Computer: NEW
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]TCP Provider: An existing
connection was
forcibly closed by the remote host.
Type: Error
Date: 07/03/2008
Time: 8.54.24
Event: 19019
Source: MSSQL$INSTNEW
Category: Failover
User: N/A
Computer: NEW
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
message = [Microsoft][SQL Native Client]Communication link failure
Type: Error
Date: 07/03/2008
Time: 8.54.24
Event: 19019
Source: MSSQL$INSTNEW
Category: Failover
User: N/A
Computer: NEW
Description:
[sqsrvres] OnlineThread: QP is not online.
They occours every time in this order. 6-7 times a day.
I've searched but individually, they seem to be generics errors.
Could you help me?
Thanks in advance
TonyThat is the cluster service checking to see if the SQL Server is responsive.
Get enough of those in a row, and cluster serv tries to restart or failover
the sql group
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Tony_da_Roma" <killerloop@.post.com> wrote in message
news:ff950762-ed63-4c69-9e5e-f45a5386b2e4@.n58g2000hsf.googlegroups.com...
> Hi all,
> I encounter many of this errors in Application event viewer regarding
> SQL server 2005:
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
> message = [Microsoft][SQL Native Client]TCP Provider: An existing
> connection was
> forcibly closed by the remote host.
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746;
> message = [Microsoft][SQL Native Client]Communication link failure
>
> Type: Error
> Date: 07/03/2008
> Time: 8.54.24
> Event: 19019
> Source: MSSQL$INSTNEW
> Category: Failover
> User: N/A
> Computer: NEW
> Description:
> [sqsrvres] OnlineThread: QP is not online.
> They occours every time in this order. 6-7 times a day.
> I've searched but individually, they seem to be generics errors.
> Could you help me?
> Thanks in advance
> Tony

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properly
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patched
What are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:

> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character properly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 server
> is all up to date and patched
|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
[vbcol=seagreen]
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properl
y
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patchedWhat are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:

> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character prope
rly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 serv
er
> is all up to date and patched|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
[vbcol=seagreen]
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:
>

French character problems

I am having a problem where if I connect with our application to the sql
server from a windows2000 terminal server I see the French character properly
but if I connect to the same database from windows2003 i only see wird
character insted of é or è.
it's hard to explane but dose anyone know what this could be the 2003 server
is all up to date and patchedWhat are your regional settings on win2k and win2003?
See if its different, change it and try.
"Mart" wrote:
> I am having a problem where if I connect with our application to the sql
> server from a windows2000 terminal server I see the French character properly
> but if I connect to the same database from windows2003 i only see wird
> character insted of é or è.
> it's hard to explane but dose anyone know what this could be the 2003 server
> is all up to date and patched|||I had tryed that but now I found that the Mdac's were the problem
thanks
"Me" wrote:
> What are your regional settings on win2k and win2003?
> See if its different, change it and try.
>
> "Mart" wrote:
> > I am having a problem where if I connect with our application to the sql
> > server from a windows2000 terminal server I see the French character properly
> > but if I connect to the same database from windows2003 i only see wird
> > character insted of é or è.
> >
> > it's hard to explane but dose anyone know what this could be the 2003 server
> > is all up to date and patched

freeze header

Hello,
I am using ReportViewer control in my asp.net application. It works fine,
however is it possible to keep header frozen when I scroll-down?
Thanks,
Jim.Not presently - you might be able to solve this by creating two browser
controls one above the other. The first which shows the headers and the
second to show the data. This would be pretty hacky.
We're look at this feature for a future version.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <JIMH@.discussions.microsoft.com> wrote in message
news:7B5913F6-72E2-4AC4-97EA-A77AF945F3F9@.microsoft.com...
> Hello,
> I am using ReportViewer control in my asp.net application. It works fine,
> however is it possible to keep header frozen when I scroll-down?
> Thanks,
> Jim.
>

freetexttable issue

Hi,

We are using freetexttable as our search function in our application and it seems to be partially working. I search for a word from a column of a table I included in the search catalog and it sometimes pickup the record and sometimes it doesn't. I got 2 records having 'business' as the keyword. And when I search that keyword, it only returned 1 record.

here is the codesnippet:

select * from freetexttable(<tablename>, *, 'business')

Any help is greatly appreciated.

Baldwin

bbudiongan@.misicompany.com

Are the two keyword int he same column ? if no, are there different word breakers defined on the column ? Are the two columns freetextindexed ?

Jens Suessmeyer.

http://www.sqlserver2005.de

freetexttable issue

Hi,
I am using freetexttable as a search tool for our application but it
seems that it is partially working. I am able to search on some words
specified in my catalog but not on others. For example I got keywords
- stamps business cards. The freetexttable function can pick up only
'stamps' but not 'business'. I created another record in the table
included in the catalog and have the same keywords. Now I can search
on 'stamps' of the first record but not on the second record.
here is the code snippet:
select * from freetexttable(<table name>, *, 'keywordhere')
where: tablename is included in the catalog
keywordhere is the keyword in which i use 'stamps' or
'business'.
Any help is greatly appreciated.
thanks!
Baldwin
Can you try this
select * from freetexttable(<table name>, *, 'Stamps')
select * from freetexttable(<table name>, *, 'business')
select * from freetexttable(<table name>, *, 'Cards')
Do the same rows show up?
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ibaldwinjr@.gmail.com> wrote in message
news:1184851168.766256.92770@.z28g2000prd.googlegro ups.com...
> Hi,
> I am using freetexttable as a search tool for our application but it
> seems that it is partially working. I am able to search on some words
> specified in my catalog but not on others. For example I got keywords
> - stamps business cards. The freetexttable function can pick up only
> 'stamps' but not 'business'. I created another record in the table
> included in the catalog and have the same keywords. Now I can search
> on 'stamps' of the first record but not on the second record.
> here is the code snippet:
> select * from freetexttable(<table name>, *, 'keywordhere')
> where: tablename is included in the catalog
> keywordhere is the keyword in which i use 'stamps' or
> 'business'.
> Any help is greatly appreciated.
> thanks!
> Baldwin
>

FREETEXT Help please

Hi All... I'm trying to play around with the "FREETEXT" function to see if it might help us with our application. I have a column of type "text" and I understand it needs to have the Full-text specification set to yes. But I cant seem to figure out how to do that. Can anyone help me out with this please?

Thanks! -- Curt

FreeText is not a function, it is a predicate used for FullText index searches, if you cannot find Full Text the questions is what version and edition of SQL Server are you using. In 2000 it is a separate install and it is not avalable in Express by default you have to use code to implement it. All other editions of 2005 you can enable it either from the menu or right click in Management Studio. Here are all the Full Text predicates CONTAINS, CONTAINSTABLE, FREETEXT and FREETEXTTBALE, run a search for all in the BOL(books online). Hope this helps.

Free MS SQL Hosting??

Hi,
I need a MS SQL host that I can use for about a month for testing of a
C# application. Does anyone know of a host that I can use for free?
Would only need about 20mb with only the sql server will not need a
website host..
Thanks in advance
Why not buy Developer Edition? It is only about 50-60 bucks, or so.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter petehdd" <petehdd@.invalid.com> wrote in message
news:pnJehgyGmh53T3rHpetehdd@.fe06.highwinds-media.phx...
> Hi,
> I need a MS SQL host that I can use for about a month for testing of a
> C# application. Does anyone know of a host that I can use for free?
> Would only need about 20mb with only the sql server will not need a
> website host..
> Thanks in advance
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O$T4lV$%23FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Why not buy Developer Edition? It is only about 50-60 bucks, or so.
> --
Or download the free Express Edition
http://www.microsoft.com/sql/edition...s/default.mspx
Or a Trial Edition
http://www.microsoft.com/sql/downloa...-software.mspx
David

Free MS SQL Hosting??

Hi,
I need a MS SQL host that I can use for about a month for testing of a
C# application. Does anyone know of a host that I can use for free'
Would only need about 20mb with only the sql server will not need a
website host..
Thanks in advanceWhy not buy Developer Edition? It is only about 50-60 bucks, or so.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter petehdd" <petehdd@.invalid.com> wrote in message
news:pnJehgyGmh53T3rHpetehdd@.fe06.highwinds-media.phx...
> Hi,
> I need a MS SQL host that I can use for about a month for testing of a
> C# application. Does anyone know of a host that I can use for free'
> Would only need about 20mb with only the sql server will not need a
> website host..
> Thanks in advance|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O$T4lV$%23FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Why not buy Developer Edition? It is only about 50-60 bucks, or so.
> --
Or download the free Express Edition
http://www.microsoft.com/sql/editions/express/default.mspx
Or a Trial Edition
http://www.microsoft.com/sql/downloads/trial-software.mspx
David

Free MS SQL Hosting??

Hi,
I need a MS SQL host that I can use for about a month for testing of a
C# application. Does anyone know of a host that I can use for free'
Would only need about 20mb with only the sql server will not need a
website host..
Thanks in advanceWhy not buy Developer Edition? It is only about 50-60 bucks, or so.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Peter petehdd" <petehdd@.invalid.com> wrote in message
news:pnJehgyGmh53T3rHpetehdd@.fe06.highwinds-media.phx...
> Hi,
> I need a MS SQL host that I can use for about a month for testing of a
> C# application. Does anyone know of a host that I can use for free'
> Would only need about 20mb with only the sql server will not need a
> website host..
> Thanks in advance|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O$T4lV$%23FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Why not buy Developer Edition? It is only about 50-60 bucks, or so.
> --
Or download the free Express Edition
http://www.microsoft.com/sql/editio...ss/default.mspx
Or a Trial Edition
http://www.microsoft.com/sql/downlo...l-software.mspx
David